Content Fee Errors [#208964]

Content Fee Report Page:
user warning: Table 'fab5ent.paypalnode_node' doesn't exist query: SELECT pn.nid, n.title, u.name, pn.price, n.created, npc.discount, IF(npc.discount, (pn.price - ((npc.discount/100)*pn.price)), (pn.price)) AS final_price FROM node n INNER join users u ON u.uid = n.uid INNER JOIN paypalnode_node pn ON pn.nid = n.nid LEFT JOIN nodepromocode_node npc ON npc.nid = n.nid WHERE n.type = 'story' AND n.status = 1 in c:\program files\easyphp\www\fab5\includes\database.mysql.inc on line 172.

Content Fee Page

    * warning: rsort() expects parameter 1 to be array, string given in c:\program files\easyphp\www\fab5\modules\paypalnode\paypalnode-admin.inc on line 186.
    * warning: Invalid argument supplied for foreach() in c:\program files\easyphp\www\fab5\modules\paypalnode\paypalnode-admin.inc on line 188.
    * user warning: Table 'fab5ent.paypalnode_prices' doesn't exist query: SELECT * FROM paypalnode_prices WHERE price != 0 ORDER BY pid in c:\program files\easyphp\www\fab5\includes\database.mysql.inc on line 172.

Comments

Comment #1

TheDarkFlop commented 11 January 2008 at 21:09

Status:

Active

» Needs review

If you have any errors like this on the content fee page or content fee report page, the best thing to is to reinstall the module by unchecking and rechecking (reinstalling) the the module on the module page after the patch has been applied below.

To fix this you need to apply this patch located here.
http://drupal.org/node/208411

Also you will get errors if you don't have any taxonomy asscociated with the paypal module.
Set this under administration > Site Configuration > Paypal Node

Comment #2

apt94jesse commented 18 January 2008 at 15:46

This is not the fix for this problem. The module is actually not creating the tables in the database. This fixes the install problem with the php error, but not the tables not found mysql errors.

I have both errors. Your patch fixed the first installation error, then this mysql error showed up.

Comment #3

TheDarkFlop commented 19 January 2008 at 19:52

This error is caused because of the tables not fully installing when the .install file is run, ALSO
you need to have taxomony associated with paypalnode. Other wise it will throw this error.

Option 1 : can uninstall everything in database manually and reinstall everything with the patch.

Option 2: Go into the .install file for paypal node. Look for one of the first functions that has the word install in it.
Copy the contents of that function into a page or a block. Then run that page or block.(RUN ONLY ONCE)
That will install all of the tables that you need.

AFTER EITHER ONE: Then add the taxonomy you want paypal to use..

hOPe this helps :)
-thedarkflop