# warning: Missing argument 3 for cache_set(), called in /var/www/vhosts/beta.com/httpdocs/drupal/sites/all/modules/affiliates/affiliates.module on line 463 and defined in /var/www/vhosts/beta.com/httpdocs/drupal/includes/cache.inc on line 94.
# user warning: Incorrect table name 'tabletheadtrthRankththUserththTotalththPeriodththProfilethtrtheadtbodytrclassoddtdcolspan2Noclicksye' query: LOCK TABLES tabletheadtrthRankththUserththTotalththPeriodththProfilethtrtheadtbodytrclassoddtdcolspan2Noclicksyettdtrtbodytable WRITE in /var/www/vhosts/beta.activelyOUT.com/httpdocs/drupal/includes/database.mysql.inc on line 174.
# user 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 '

Rank User Total Period P' at line 1 query: UPDATE
Rank User Total Period Profile
No clicks yet

SET data = '', created = 1233122990, expire = 0, headers = '' WHERE cid = 'affiliate_top_users_page' in /var/www/vhosts/beta.com/httpdocs/drupal/includes/database.mysql.inc on line 174.
# warning: Missing argument 3 for cache_set(), called in /var/www/vhosts/beta.activelyOUT.com/httpdocs/drupal/sites/all/modules/affiliates/affiliates.module on line 496 and defined in /var/www/vhosts/beta.com/httpdocs/drupal/includes/cache.inc on line 94.
# user warning: Table 'beta.tabletbodytrclassoddtdcolspan3Noclicksyettdtrtbodytable' doesn't exist query: LOCK TABLES tabletbodytrclassoddtdcolspan3Noclicksyettdtrtbodytable WRITE in /var/www/vhosts/beta.activelyOUT.com/httpdocs/drupal/includes/database.mysql.inc on line 174.

Comments

Anonymous’s picture

Anonymous (not verified) commented

Would you try downloading 5.x-1.0 again and see if you still have this problem.

Thanks, Paul

socialnicheguru’s picture

socialnicheguru commented

this was 1.0.

the incorrect table name is a strange one.

Anonymous’s picture

Anonymous (not verified) commented
Assigned: Unassigned »

I couldn't reproduce this problem.

Would you mind investigating your problem. Try the affiliates module installed on a clean drupal 5 install and see if you experience any problems . If not , then develop this installation so that it mirrors more closely your actual installation
testing at every stage for the above problem.

Let me know how you get on :-)

Paul

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

Please reopen if you need assistance.

Best, Paul

jusyjim’s picture

jusyjim commented

I have also gotten the same errors when manually running cron.

obsidiandesign’s picture

obsidiandesign commented

The code applied in #154047: cache_set and module_exists patch on October 23, 2008 did not get released as a separate version. 5.x-1.0 does not contain the proper code for cache_set, which causes the error. If you release a new version with the changes from 5.x-1.x-dev, the error should go away.