Add ons. New install.

[rclafton]

Hi all...

I have just done a clean install of 1.7.

All ok apart from when I click on the addon's in the admin panel.

I get this error: Table 'clafton.pixelpost_ping' doesn't exist

www.Clafton.com is the site

I can guarantee it's something I did! ;-) BUt if you can point in the direction of my mistake I would be very happy! Thanks!

Richard
------------------------------------------------------------


Here is the general info of my server:

Host Information

URL http://www.clafton.com/admin/index.php
PHP-version 5.2.0 (Pixelpost's min requirement: PHP version: 4.3.0 )

Session save path C:/Windows/temp

MySQL version 5.0.27-community-nt (Pixelpost's min requirement: MySQL: 3.23.58 )

GD-lib bundled (2.0.28 compatible) with JPEG support

File Uploads to Pixelpost site are possible.

Server Software Microsoft-IIS/6.0

EXIF Pixelpost is using exifer v1.5 for EXIF-information.


Paths
Guessed imagepath: /images/
Configured Imagepath: ../images/

Guessed thumbnailpath /thumbnails/

Configured Thumbnailpath ../thumbnails/

Image Directory: OK - Can we write to the directory? YES. Current CHMOD: 0777

Thumbnails Directory: OK - Can we write to the directory? YES. Current CHMOD: 0777

Language Directory: OK

Addons Directory: OK

Includes Directory: OK

Templates Directory: OK

[austriaka]

the table pixelpost_ping should be created when calling the addon page with the Ping Service Addon.

Please assure that the file admin_ping.php is located in the addons folder. You should replace this file by the one of the original download, perhaps something went wrong with copying or uploading.
Then re-upload it onto your server and call the admin page.
If the error still is there, please add "&errors" to the URL in the address bar of your server and reload the page.

Copy and paste all of the error messages you see now here into the forum.

[raulitosbd]

I has the same problem whit this mysql_error:
BLOB/TEXT column 'pinglist' can't have a default value

You must modified the file admin_ping.php, in addons folder, and replace at line 70:

$query = "CREATE TABLE {$pixelpost_db_prefix}ping (
id INT(11) NOT NULL auto_increment,
pinglist MEDIUMTEXT NOT NULL default '',
PRIMARY KEY (id)
)";

for:

$query = "CREATE TABLE {$pixelpost_db_prefix}ping (
id INT(11) NOT NULL auto_increment,
pinglist MEDIUMTEXT NOT NULL,
PRIMARY KEY (id)
)";

---> only delete -- (default '')