My PP1.7 could not use Addon function...

[hoolaa]

Hi,

PP1.7.1 is really an good photoblog system.

And i tried to install it and seems everything is fine, but when i go to ADDON tab in the control panel, and there is one line said:"Table 'XXXusername.pixelpost_ping' doesn't exist". And after this line, there is nothing showed on ADDON page. Addon is non-visiable to me.

May i know what happend?? Cause i want to turn on the page_archive function..Or maybe i could try ohter addon for fun...But seems i could not do anything for ADDon error...

I checked MySQL database, and found below tables existed, am i miss any table not installed??

# pixelpost_addons
# pixelpost_catassoc
# pixelpost_categories
# pixelpost_comments
# pixelpost_config
# pixelpost_defensio
# pixelpost_pixelpost
# pixelpost_stats
# pixelpost_tags
# pixelpost_version
# pixelpost_visitors


If i miss an table not installed, could you kindly advise which table i missed? And could it possible to install that table seperately without re-installing the whole PP again??

And i tried: http://www.mydomain.com/admin/index.php?view=addons&errors
Then got below info:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in e:\www\web\mydomain.com\wwwroot\addons\paged_archi ve.php on line 637

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in e:\www\web\mydomain.com\wwwroot\includes\functions .php on line 813
Table 'XXXuser.pixelpost_ping' doesn't exist

Could you kindly help me? Thank you very much!

[hoolaa]

Seems there is a table called 'pixelpost_ping' is missing, then i reupload the ori-download 1.7.1 file admin_ping to my server. And problem still there..

Then i go to admin_ping.php found line 67 and line 68, there looks like if the table not exist, then creat it...

Then i just follow the step in my MYSQL server and excute below query, but got error like below said:


SQL query:

CREATE TABLE pixelpost_ping(
id INT( 11 ) NOT NULL AUTO_INCREMENT ,
pinglist MEDIUMTEXT NOT NULL default '',
PRIMARY KEY ( id )
)

MySQL said: Documentation
#1101 - BLOB/TEXT column 'pinglist' can't have a default value


Hope could get help from you, thank you very much!!

[hoolaa]

oh...Seems the problem is resolved...

Cause Mysql said below:
#1101 - BLOB/TEXT column 'pinglist' can't have a default value


Then i tried to change the query without 'default ''' for field pinglist like below:

CREATE TABLE pixelpost_ping(
id INT( 11 ) NOT NULL AUTO_INCREMENT ,
pinglist MEDIUMTEXT NOT NULL,
PRIMARY KEY ( id ))

Oh!! It works!! Pixelpost_ping table generated sucessfully!! And then i go to ADMIN page-->ADDON page...

Everything is okay now.

Thanks!! I am pretty happy now.