A lot of errors after install & when trying to config.

HS - December 25, 2008 - 02:39
Project:Kudos
Version:6.x-1.3
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed
Description

Hi this is my second attempt in trying to get this module to work. I used an aloder version months back and got a WSOD after install, now I get the following errors.

    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , 0 as given FROM drupal_kudos_info i in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 305.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT id, name, label, status, comments, icon_give, icon_rescind, icon_disabled FROM drupal_kudos_info WHERE id = '-1' in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 655.

user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , (SELECT 1 FROM drupal_kudos_granted g WHERE g.kudo_id = i.id and g.content_type = 'node' AND g.content_id = 318 AND g.uid = 1) as given FROM drupal_kudos_info i JOIN drupal_kudos_info_types t ON i.id = t.kudo_id AND t.node_type = 'poll' WHERE i.status = 1 in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 305.



    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , 0 as given FROM drupal_kudos_info i in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 305.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT id, name, label, status, comments, icon_give, icon_rescind, icon_disabled FROM drupal_kudos_info WHERE id = '-1' in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 655.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: INSERT INTO drupal_kudos_info (name, label, status, comments, icon_give, icon_rescind, icon_disabled) VALUES ('top_post', 'Great post', 1, 0, '', '', '') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 464.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info_types' doesn't exist query: INSERT INTO drupal_kudos_info_types (kudo_id, node_type) VALUES (7438, 'blog') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 477.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info_types' doesn't exist query: INSERT INTO drupal_kudos_info_types (kudo_id, node_type) VALUES (7438, 'forum') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 477.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info_types' doesn't exist query: INSERT INTO drupal_kudos_info_types (kudo_id, node_type) VALUES (7438, 'image') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 477.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info_types' doesn't exist query: INSERT INTO drupal_kudos_info_types (kudo_id, node_type) VALUES (7438, 'cricket_news') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 477.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info_types' doesn't exist query: INSERT INTO drupal_kudos_info_types (kudo_id, node_type) VALUES (7438, 'poll') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 477.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info_types' doesn't exist query: INSERT INTO drupal_kudos_info_types (kudo_id, node_type) VALUES (7438, 'cricket_video') in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.module on line 477.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , 0 as given FROM drupal_kudos_info i in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 305.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT id, name, label, status, comments, icon_give, icon_rescind, icon_disabled FROM drupal_kudos_info WHERE id = '-1' in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 655.



    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , 0 as given FROM drupal_kudos_info i in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 305.
    * user warning: Table 'islandcricket_db_drupal.drupal_kudos_info' doesn't exist query: SELECT id, name, label, status, comments, icon_give, icon_rescind, icon_disabled FROM drupal_kudos_info WHERE id = '-1' in /home/islandcricket/islandcricket.lk/modules/kudos/kudos.inc on line 655.

#1

HS - January 16, 2009 - 18:46

Even un installing the module is giving me errors and user warnings:

    * warning: Invalid argument supplied for foreach() in /home/islandcricket/islan..../includes/common.inc on line 3279.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/islan.../includes/common.inc on line 3225.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/islan.../includes/common.inc on line 3279.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/isla.../includes/common.inc on line 3225.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/isla.../includes/common.inc on line 3279.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/isla.../includes/common.inc on line 3225.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/islan.../includes/common.inc on line 3279.
    * warning: Invalid argument supplied for foreach() in /home/islandcricket/islan.../includes/common.inc on line 3225.

#2

socki - December 26, 2008 - 01:34

Are you using mysql? What version?

#3

HS - December 26, 2008 - 06:36

MYsql 5.0.67

#4

teru - January 27, 2009 - 19:22

I've also got the following warning. (6.x-1.x-dev (2009-Jan-12) MySQL 5.0.67)

user warning: Unknown column 'nodes' in 'field list' query: SELECT id, name, label, status, comments, nodes, icon_give, icon_rescind, icon_disabled FROM kudos_info WHERE id = '-1' in /var/www/aristoy/sites/all/modules/kudos/kudos.inc on line 686.

when I accessed a blog I got this warning.

user warning: Unknown column 'i.nodes' in 'where clause' query: SELECT i.id, i.name, i.label, i.status, i.comments, i.icon_give, i.icon_rescind, i.icon_disabled , (SELECT 1 FROM kudos_granted g WHERE g.kudo_id = i.id and g.content_type = 'node' AND g.content_id = 27 AND g.uid = 1) as given FROM kudos_info i JOIN kudos_info_types t ON i.id = t.kudo_id AND t.node_type = 'blog' WHERE i.nodes = 1 AND i.status = 1 in /var/www/aristoy/sites/all/modules/kudos/kudos.inc on line 336.

#5

socki - February 2, 2009 - 14:46
Status:active» postponed (maintainer needs more info)

teru: have you recently upgraded the module?

Can you please try running update.php.

Let me know if that works.

Thanks.

#6

phonydream2 - February 7, 2009 - 08:36

I did a fresh install. There is no field in the mysql database called 'nodes' for the 'kudos_info' table. The kudos.install file doesn't refer to it anywhere either.

Should line 336 in kudos.inc read 'i.comments' instead of 'i.nodes'?

I've changed it to that and I'm getting no errors. However, I haven't tested kudos out yet so I can't assume it's working.

Note: I'm using nodecomments instead of the core drupal comments module.

#7

teru - February 12, 2009 - 07:50

I'm very sorry not to reply to you for a long time.
I had the first meet up of my project so that I didn't have time for checking this forum.
>>teru: have you recently upgraded the module?
Yes, I did.
>>Can you please try running update.php.
I'm sure I updated!!
socki-san, I still have this warning.
user warning: Unknown column 'nodes' in 'field list' query: INSERT INTO kudos_info (name, label, status, comments, nodes, icon_give, icon_rescind, icon_disabled) VALUES ('kudos', 'Kudos', 1, 1, 1, '', '', '') in /var/www/aristoy/sites/all/modules/kudos/kudos.module on line 510.
user warning: Unknown column 'nodes' in 'field list' query: SELECT id, name, label, status, comments, nodes, icon_give, icon_rescind, icon_disabled FROM kudos_info WHERE id = '-1' in /var/www/aristoy/sites/all/modules/kudos/kudos.inc on line 686.

#8

nikitas - February 14, 2009 - 18:01

same situation here ! lots of mistake . . . the database queries that run during the installation of this module is def. the problem. to that.
Exactly the same errors as above. #1 #4 #7 and the first one.
I'm using wamp 2 but i see in phpmyadmin this warning

Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.30. This may cause unpredictable behavior.

can it be this?

#9

socki - February 14, 2009 - 22:15

Hey,

I think the problem is that for some reason or another, one (or more) of the update queries in the .install file are not being executed properly. I'm currently in transit and will check this out when i return.

This looks like i may be missing the { } brackets around one or more of the queries in .install or maybe even in code.

Sorry for the delay.

#10

socki - March 9, 2009 - 02:22
Status:postponed (maintainer needs more info)» fixed

Thank you. It seems that the install hook within the module was not being caught properly due to an improperly named function declaration.

This has been addressed in version 1.5 of the D6 branch.

#11

System Message - March 23, 2009 - 02:30
Status:fixed» closed

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

#12

mcload - March 27, 2009 - 13:28
Status:closed» active

I did a fresh install of Kudos 1.5 on Drupal 6. First, configured it via /admin/settings/kudos. Then I moved to page /admin/content/kudos, but this page gave me this warning:

user warning: Unknown column 'nodes' in 'field list' query: SELECT id, name, label, status, comments, nodes, icon_give, icon_rescind, icon_disabled FROM dru_kudos_info WHERE id = '-1' in /home/r/public_html/d/sites/all/modules/kudos/kudos.inc on line 686.

It looks like the same warning as Teru received, so I think problem has not fixed in version 1.5

#13

socki - May 1, 2009 - 00:51
Status:active» fixed

This has been fixed in version 1.6.

#14

System Message - May 15, 2009 - 01:00
Status:fixed» closed

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

 
 

Drupal is a registered trademark of Dries Buytaert.