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 |
Jump to:
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
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
Are you using mysql? What version?
#3
MYsql 5.0.67
#4
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
teru: have you recently upgraded the module?
Can you please try running update.php.
Let me know if that works.
Thanks.
#6
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
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
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
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
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
Automatically closed -- issue fixed for 2 weeks with no activity.
#12
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
This has been fixed in version 1.6.
#14
Automatically closed -- issue fixed for 2 weeks with no activity.