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 453 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 451 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 452 days ago | Permalink | Hide Replies

    Typo

    | Posted 454 days ago | Permalink | Hide Replies

    Typo

    | Posted 454 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 455 days ago | Permalink | Hide Replies

Who Upvoted this Story

Pligg.com's Support area is where you can ask questions and get answers. Just getting started with the Support area? This section describes tips for participating.

Submitting a Question or Comment

By taking a minute to research previous posts you may receive an answer much faster than waiting for a response to a new question. Begin by searching the support section for an answer. Sometimes you may even want to extend your search to the entire pligg.com domain.

If you are unable to find a relevant answer, submit a new question or comment here. Please provide a detailed description and, when necessary, debugging information such as your server environment (a link to a <?php phypinfo(); ?> .php page would be very helpful), your web browser, and any steps necessary to reproduce your issue.

Submitting an Answer

If you have an answer or useful response that you would like to add to a post, you can submit it as a comment which other users will then vote on. Answers are sorted by most popular to least, allowing the best information to climb to the top of the page.

Please read and vote for existing answers before submitting your own, as there may already be an acceptable answer provided. You can use the "Reply" link found within an answer to submit a response to it, in case you want to expand or comment on someone else's contribution.

Including Files or Code

Sometimes it is necessary for you to attach a file or include a snippet of code for others to reference in your response. In most cases, you can .zip up files and attach them to a question or answer using Pligg's file manager. At times though this may fail, and in these circumstances we recommend using a third party host. Below we are including a list of recommended websites where you can share easily share file uploads (or snippets of code) through the web.