Pixelpost

lysip · #1 08-28-2005, 06:50 PM

While installing, specificly in the par that create's the table's

Code:

create_tables.php:216
// Timezone support, the 0 will be included automatically, so no need to insert
	$tz = date("Z")/3600; // set the default timezone value equal to the server timezone
	mysql_query("
	ALTER TABLE `{$prefix}config` ADD `timezone` FLOAT DEFAULT '".$tz."' NOT NULL
	") or die("Error: ". mysql_error());
	echo "Added timezone support...<p />";

I get can not connect errors... it seems to try and default to the localhost ip and not my mysql server which is on a diffrent machine. Im not sure if this is a php/mysql error or a script error, tho it seems your scripts are fine as best i can tell. If anybody has an answer to this let me know.

P.S. Forgot to say that its not just that line its all the ALTER TABLE querys in that file.

**Joe[y]**+ · #2 08-28-2005, 06:55 PM

did you modify pixelpost.php to include the location of your remote database?

lysip · #3 08-28-2005, 06:58 PM

Yes of course, it create's all the tables and such except for those in the 1.4 section, erm well it dies when it gets to them but if i remove the die from the commands and run it then it skips over it and die's on the next one.

**GeoS**+ · #4 08-29-2005, 08:25 PM

Which MySQL version do you have??

It seems that your DB can't figure out with its update code :/

lysip · #5 08-30-2005, 12:53 AM

newest mysql 4, my shell admin just receptly updated.

**GeoS**+ · #6 08-30-2005, 08:45 AM

1. Give us exect version!
4.0.x??

2. Give us exact PHP/MySQL error!

PS Remember: place in code where is error is nothing helpful without error message!!

lysip · #7 09-01-2005, 07:43 PM

I do not know as i do not run it on my own server... and php is in safemode i think with phpinfo() blocked... samething with mysql... except i knwo he just recently updated his mysql. and i know its php 4 something.... I also noticed that its not connecting on those querys to the remote database, its defaulting to localhost i think... not sure about the localhost ip but its diffrent then my mysql database ip.

all the info i can give you is right there...

*EDIT* ahh and yes i am useing phpbb2 atm with no problems... so it would seem to be your scripts...

**GeoS**+ · #8 09-01-2005, 08:03 PM

If you have same DB for phpbb2 and pixelpost then put same data to /includes/pixelpost.php.
If it still doesnt work write back to us here.

PS Maybe you dont have permissions to add new tables in your DB??

lysip · #9 09-01-2005, 08:09 PM

It creates the tables, it just has errors on alter tables... i might not have permision for thjat i guess... my pixelpost.php file is how it shoudl be... exact info that i need and such... i can view the tables in phpmysqladmin... there all set up except for teh alter table querys... the only orther way i can think of getting it working is to manualy add them to the db but its just not worth it to do that... seeing as there are many orther similer scripts out there similar to this one... I just thought i would use the best... but until i resolve this im stuck with something else..

Pixelpost

Authentic Photoblog Flavour