Hi since last update the appbar doesn't work more here. Is possible to have a diff of the previous version?

I'm with drupal 6, database postgres 8.3, here the error log:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "appbar" does not exist in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT * FROM appbar WHERE (uid = 1 OR (uid = 0 AND alert_time > (SELECT created FROM users WHERE uid = 1))) AND status = 1 ORDER BY tid DESC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 366.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "appbar" does not exist in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT * FROM appbar WHERE (uid = 1 OR (uid = 0 AND alert_time > (SELECT created FROM users WHERE uid = 1))) AND status = 1 ORDER BY tid DESC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 366.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "appbar" does not exist in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT * FROM appbar WHERE (uid = 1 OR (uid = 0 AND alert_time > (SELECT created FROM users WHERE uid = 1))) AND status = 0 ORDER BY tid DESC LIMIT 5 OFFSET 0 in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 383.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ORDER" LINE 1: ...ppbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY t... ^ in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE appbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY tid ASC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 393.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "appbar" does not exist in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT * FROM appbar WHERE (uid = 1 OR (uid = 0 AND alert_time > (SELECT created FROM users WHERE uid = 1))) AND status = 1 ORDER BY tid DESC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 366.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "appbar" does not exist in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT * FROM appbar WHERE (uid = 1 OR (uid = 0 AND alert_time > (SELECT created FROM users WHERE uid = 1))) AND status = 0 ORDER BY tid DESC LIMIT 5 OFFSET 0 in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 383.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ORDER" LINE 1: ...ppbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY t... ^ in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE appbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY tid ASC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 393.

Comments

icecreamyou’s picture

icecreamyou commented
Status: Active » Postponed (maintainer needs more info)

The diff is here, and you can always get that from CVS. Nothing has changed that would affect your errors in months.

From what I've read about this error, it only happens when the table can't be found, usually because it's referenced using different capitalization than the actual table name has. That shouldn't be the case here though unless you've been messing with the database yourself. Check in your database and make sure the table name is all lower-case.

Also try completely reinstalling the module (completely delete the appbar folder from your modules directory after uninstalling but before reinstalling).

iwkse’s picture

iwkse commented

Hi,
actually i've checked in the database and the tables related to appbar aren't created at all. Probably i did some mess with the db, because i removed myself the tables because i though i've removed the module but wasn't in this way. I've tried to install/reinstall and delete the folder and than again, but it's strange i can't create them back. Since this is a test installation i have to problem dropping the db and create things again from start.
Thank you

icecreamyou’s picture

icecreamyou commented
Status: Postponed (maintainer needs more info) » Fixed

Check your {system} table and see if there's still an entry for Appbar. You should really let Drupal do the uninstallation for you in the future because there's more that goes into (un)installing modules than you'd think, but you will probably be able to reinstall if you delete the appbar record from the system table.

iwkse’s picture

iwkse commented

Thank you.
I'm new to module development and such hints are still unknown (for few). i managed to install it now and create the tables. Now it's raising another error related to the syntax of a query. I'll show you the log:

# user warning: ERROR: syntax error at or near "ORDER" LINE 1: ...ppbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY t... ^ query: UPDATE appbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY tid ASC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 393.
# warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "ORDER" LINE 1: ...ppbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY t... ^ in /home/sal/www/drupal/includes/database.pgsql.inc on line 139.
# user warning: ERROR: syntax error at or near "ORDER" LINE 1: ...ppbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY t... ^ query: UPDATE appbar SET status = 0 WHERE status = 1 AND uid = 1 ORDER BY tid ASC in /home/sal/www/drupal/sites/all/modules/appbar/appbar.module on line 393.

iwkse’s picture

iwkse commented

I think in postgres you can't have an UPDATE with an ORDER BY, that's probably the reason of the error.

icecreamyou’s picture

icecreamyou commented

Alright, I dropped the "ORDER BY tid ASC" from that query.

Status: Fixed » Closed (fixed)

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