Every time I try to install either one it says my user badges database isnt found, lookign in my db its correct no tables where created :/
the error im seeing now after doing this is:
install stable version, spit out some db errors missing tables, installed dev version, did a update, now im getting this
user warning: Table '3500_mysite.user_badges_badges' doesn't exist query: SELECT DISTINCT b.bid, b.weight, b.name, b.image, b.href, b.unhideable, b.fixedweight, b.doesnotcounttolimit, u.userweight, b.tid, CASE WHEN b.fixedweight = 1 THEN b.weight ELSE COALESCE(u.userweight,b.weight) END coalescedweight FROM user_badges_badges b INNER JOIN user_badges_user u ON b.bid = u.bid WHERE u.uid = 1 ORDER BY coalescedweight, b.name in /usr/www/virtual/gateway/www.mysite.com/sites/all/modules/user_badges/user_badges.module on line 768.
looking in the db, I do not see any user_badges tables listed at all..
thoughts? help?
Drupal 6.15
Mysql
# Server version: 5.0.45
# Protocol version: 10
PHP 5.2.9 (cli) (built: Apr 15 2009 21:29:05)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2007, by Zend Technologies
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | user_badges_install_fix.patch | 442 bytes | jcmarco |
| #2 | user_badges-sql.zip | 1.53 KB | magnus |
Comments
Comment #1
gateway69 commentedseems that no database is being created, can someone give me a sql dump of the basic db, this might help
Comment #2
magnus commentedI guess this is a duplicate of #643584: -dev does not properly create/manipulate tables. Attached is the SQL dump you wanted. Both from the 6.x-1.5, and the dev that I manually edited in the DB.
Comment #3
gateway69 commentedThank you!
Comment #4
jcmarco commentedThis patch fix the typo in the install file.
It works at least installing and uninstalling from the dev release.
Probably it would be required some extra updates functions to move from v.1.5 format to the new dev format.
But at least it is possible to install it and start working with the dev version.
Comment #5
nancydruThis should be a duplicate of #643584: -dev does not properly create/manipulate tables and the patch moved there.
Comment #6
nancydru