PDA

View Full Version : fresh install probs


Snoops
10-05-2007, 03:54 PM
ok im installing for a mate on his host... and all i getting is this

Notice: Undefined variable: images_path in webroot\includes\create_tables.php on line 126
Table pixelpost_config populated ...
Table pixelpost_version created ...
Table pixelpost_catassoc created ...
Added timezone support ...
Added customizable category links support ...
Added HTML notification email support ...
Added email in comments support ...
Longer name field in comments support ...
Longer url field in comments support ...
Added indexes to pixelpost_config ...
Added indexes to pixelpost_categories ...
Added indexes to pixelpost_comments ...
Added indexes to pixelpost_pixelpost ...
Added indexes to pixelpost_visitors ...

Notice: Undefined variable: table_name in webroot\includes\functions.php on line 511
Comment moderation feature is added ...
Addon ON/OFF switchs are added ...

Notice: Undefined variable: table_name in webroot\includes\functions.php on line 511
Switch ON/OFF for time stamps is added ...

Notice: Undefined variable: table_name in webroot\includes\functions.php on line 511
Switch ON/OFF for visitor booking is added ...
Table pixelpost_version updated to 1.5Beta.

Notice: Undefined variable: table_name in webroot\includes\functions.php on line 511
Error: BLOB/TEXT column 'alt_body' can't have a default value

what am i doing wrong??
i just installed this on my own domain again to make sure i was doing it right...

is there any info you need in order to help me please???

its driving me **** nuts

Snoops
10-05-2007, 04:42 PM
ok i fixed this by taking teh DB SQL and manually inserting it into my friends SQL and manually editing the pixelpost_config myself...

i have no idea why it wouldnt work .... with the install.php tho

Dkozikowski
10-05-2007, 06:33 PM
The output says it all.

Error: BLOB/TEXT column 'alt_body' can't have a default value

I understand that if you don't know your way around PHP then that means nothing to you. So, here's a little explanation:

Most (if not all) databases do not allow a "blob" or "text" column to contain a default value.
So, with that in mind, an invalid SQL query would look something like this:

ALTER TABLE `pixelpost_pixelpost` ADD `alt_body` TEXT NOT NULL DEFAULT

To fix the query, you could have removed DEFAULT or added a NULL value so it would look like DEFAULT NULL


I took a look at our current SQL queries and this issue has already been corrected as far as i can tell.