PayPalNode tables not created

blogjunkie - January 17, 2008 - 16:26
Project:PayPal Node
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:budda
Status:closed
Description

Hi, when I install the module Drupal reports "PayPal Node tables installed". However that's not the case and viewing the Content Fees page gives me the following error:

warning: rsort() expects parameter 1 to be array, string given in /home/thesecr2/public_html/beta/sites/all/modules/paypalnode/paypalnode-admin.inc on line 186.
warning: Invalid argument supplied for foreach() in /home/thesecr2/public_html/beta/sites/all/modules/paypalnode/paypalnode-admin.inc on line 188.
user warning: Table 'thesecr2_olcdrupalb.paypalnode_prices' doesn't exist query: SELECT * FROM paypalnode_prices WHERE price != 0 ORDER BY pid in /home/thesecr2/public_html/beta/includes/database.mysql.inc on line 172.

Please advise

#1

apt94jesse - January 18, 2008 - 15:41

Exact same problem.

Bump.

#2

apt94jesse - January 21, 2008 - 19:28

I have installed the tables manually (through phpmyadmin) and the module seems to work now. It appears to just be a problem with the install file.

#3

budda - February 9, 2008 - 17:11
Assigned to:Anonymous» budda

The first error:

warning: rsort() expects parameter 1 to be array, string given in /home/thesecr2/public_html/beta/sites/all/modules/paypalnode/paypalnode-admin.inc on line 186.
warning: Invalid argument supplied for foreach() in

is caused by you not setting up any vocabularies that will contain terms that can have a fee associated with them. See the modules settings page. I have added a check for this and a helpful message now.

The second error:

I'm not sure on the cause - i've just run the install on a fresh Drupal 5 site running on a PHP5 and Mysql server. Had no problems.

#4

ricky7524 - February 21, 2008 - 14:04

sorry, but the problem is not fixed...
i have his error now when i try to put a content fees:

"user warning: Table 'Sql179696_1.paypalnode_prices' doesn't exist query: SELECT * FROM paypalnode_prices WHERE price != 0 ORDER BY pid in /web/htdocs/www.xbass.org/home/includes/database.mysql.inc on line 172."

i've mad every modification in paypalnode.install, ecc and i have already set a taxonomy vocabulary

#5

nedjo - March 19, 2008 - 22:05
Status:active» patch (code needs review)

The problem is in paypalnode_install(). This function needs to be updated each time there is a change in the schema. _update_x functions are not run on new installs but only on existing installs that need to be updated (e.g., to a new schema version). The _install function must always create the latest version of the schema.

Here's a quick untested patch.

AttachmentSize
paypalnode-install.patch1.99 KB

#6

JLJLJLJL - March 30, 2008 - 03:54

Same problem here. No tables created.

#7

budda - April 3, 2008 - 02:18
Version:5.x-1.2» 5.x-1.x-dev
Status:patch (code needs review)» active (needs more info)

@nedjo
I'm not sure what your patch is supposed to achieve as the .install file already defines all the required tables. See http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/paypalnode/...

#8

wallbay1 - April 12, 2008 - 08:02
Priority:normal» critical

And what are we suppose to do with that patch exactly ?
where do i upload it , in which folder?

#9

nedjo - April 26, 2008 - 21:01
Status:active (needs more info)» active

Yes, the table creation is not in the 5.x branch. You just need to issue another stable release, as the stable release is not usable for new installs.

#10

Tpainton - August 1, 2008 - 04:27

Same problem what is the fix here? Great module that seems to have a huge bug.

#11

ashiwebi - August 1, 2008 - 04:29

Create the tables manually inside the database.

#12

Tpainton - August 1, 2008 - 06:34

ok. What a pain.

#13

budda - August 15, 2008 - 23:19
Status:active» fixed

release 1.3 includes the fixed install file.

#14

Anonymous (not verified) - August 29, 2008 - 23:22
Status:fixed» closed

Automatically closed -- issue fixed for two weeks with no activity.

 
 

Drupal is a registered trademark of Dries Buytaert.