Navigation

Pligg Support

Greetings,



I upgraded to 2.0.0 last evening. Today I have 51,000.000+ repetitive entries from my error log (all identical) which I posted a snippet below:

[22-Sep-2013 03:30:00] PHP Warning: Table 'rjwusa_politicollision.pligg_additional_categories' doesn't exist in /home/rjwusa/public_html/libs/db.php on line 479

Meanwhile, I have a table in my db listed as: table_additional_categories

Is there a simple fix to this? Is it an error in db.php which needs to be edited to fix? Or, is this simply an issue of renaming the table in the db?

Thanks in advance!

Possible Answers

    So you are saying that there is a table in your database called "table_additional_categories"? If so, is 'table_' your chosen prefix for all of the Pligg tables? If not and everything else appears as 'pligg_' (the default prefix), then perhaps renaming the table to 'pligg_additional_categories' might fix your initial problem.

    What version of Pligg CMS did you upgrade from?

    | Posted 211 days ago | Permalink | Hide Replies

    Sorry Yank... I neglected to give you the version I upgraded from: Pligg CMS version 1.2.2

    Thanks!

    | Posted 209 days ago | Permalink | Hide Replies

    Hi Yank...

    I have a pligg_additional_categories in my db as well. Both the table_additional_categories and pligg_additional_categories are devoid of any information. They are empty.

    This is evidence for when I "browse" the table -- it throws the following message: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)

    Does that help?

    Thanks!

    | Posted 210 days ago | Permalink | Hide Replies

    Typo

    | Posted 212 days ago | Permalink | Hide Replies

    Typo

    | Posted 212 days ago | Permalink | Hide Replies

    More Information:

    This is a portion of my error log...

    [23-Sep-2013 19:52:56] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:54:06] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:55:53] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:56:52] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:57:13] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:57:30] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:57:43] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:57:53] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    [23-Sep-2013 19:58:33] PHP Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY saved_id DESC limit 5' at line 1 in /home/rjwusa/public_html/libs/db.php on line 479

    Any ideas?

    | Posted 212 days ago | Permalink | Hide Replies

Who Upvoted this Story