After some difficulty, I managed to install PAPs and the ioncube loader. I am hosted by GoDaddy. I notice an error when I get to the upload section of PAPs in the admin panel. The following error is listed on the top:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/b/a/s/bastardmotor/html/admin/includes/functions/extra_functions/paps_data_access.php on line 0


I should add that ioncube states that it is loaded correctly.


Any ideas on how to resolve this error or where to troubleshoot? I think it is not able to access the database for some reason.



Thanks,

Henry

I noticed that my configure.php has the following line in it:



define('DB_PREFIX', 'zen_'); // prefix for database table names -- preferred to be left empty



I also notice that PAPs states it will not work correctly with a database prefix. Since I imported PAP through the SQL patch of the ZenCart admin panel, I assume this is OK. When I look at the database in phpmyadmin, I see the zen_ prefix has been added to all tables the the PAP tables have been inserted, so maybe the problem is not there. Please help!

Hi

I'm really sorry about the delay in getting a reply to you.

There has been a problem with our ISP and we've had no internet access for nearly 24 hours at the workplace.

Please open up your database interface program PHPmyAdmin or similar, and locate the tables that hold the PAPs data. There should be 5 or 6 tables related to PAPs. For the table names, see the SQL script that you used to set up the tables when you installed it.

If the PAPs table names have had your Zen Cart database table prefix added to them, then this must be removed from each table name so that the table names are exactly as they appear in the SQL script. I'm sorry I can't give you the exact list of table names as I'm responding to you from an internet cafe and don't have all the details to hand.

If the error persists after you've checked that no table name prefixes have been added to the PAPs table names, I will be happy to investigate further by taking a look at your installation directly and fixing any lingering problems.

Kind regards

Nick

Thanks for the quick response. I removed the zen_ prefix from all the paps tables and now it seems to work, but I have a new error. It only comes up every now and then.



Warning: implode() [function.implode]: Invalid arguments passed in /home/content/b/a/s/bastardmotor/html/admin/includes/classes/paps_delegate.php on line 0

Warning: Cannot modify header information - headers already sent by (output started at /home/content/b/a/s/bastardmotor/html/admin/includes/classes/paps_delegate.php:0) in /home/content/b/a/s/bastardmotor/html/admin/includes/functions/general.php on line 21

I have been unable to get the selected attribute to the cart. I need a user to be able to select a helmet size and color to add to the cart. If I create a size attribute using the zencart options manager, it shows up and can be selected to the cart via radio button or drop down. I would like to do the same thing for helmet color via paps, but paps does not create a radio button. The user can select the option, and the picture changes, but it does not move to the cart. How can I have radio buttons appear for the thumbnails, indicating that the user must make a selection, and then move that thumbnail to the cart? I think there is something missing that the error message I included is causing.


I've sent you my cart login info, if you want to log into it and have a look yourself.


Thanks,

Henry

Hi



I can fix the problem that is causing the error but I'll need your FTP details to make the alteration to the appropriate file.



Could you send me those details via email?



Thanks



Nick

I just sent it to you now.