Thank you for your nice plugin.
I suppose i have a bug, when activating the plugin i get this:
WordPress database error:
[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 '-_wordpress LIKE 'acup_cformssubmissions'' at line 1]
SHOW TABLES FROM taijiquan_pro_br_-_wordpress LIKE 'acup_cformssubmissions'
This usually happens to me when i don't enclose my DB's name in backticks, due to the hyphen in it's name (which is
taijiquan_pro_br_-_wordpress). I would try to fix it myself, but if this is the case during the activation the bug may be spread throughout the code everywhere the name is referenced, right?
Sorry for being nosy and throwing a wild guess like this one.
March 6, 2005
You guessed right Eduardo, I think I have not used backticks anywhere in the code. As a work around you could just search in all the *.php files for
and modify where necessary (shouldn't too many).
On second thought, the code producing this line:
show tables like '$wpdb->cformssubmissions'") == $wpdb->cformssubmissions
doesn't even reference your table directly, so you may need to specifically include the "FROM.." in those "show tables" statements.
Thank you for your help. I think i found the culprit: line 142 in lib_functions.php references the DB_NAME directly. I just don't know how to fix the thing, i am not a programmer. Enclosing DB_NAME in backticks obviously didn't work.
Do you know how to fix this? I will be gratefull!
Ok, a little bit of sleep and i fixed it, hehe, just need to put the backticks inside the quotes that come before and after DB_NAME. Now the plugin is activated correctly!
Thanks a lot for your help!
Most Users Ever Online: 959
Currently Browsing this Page:
Guest Posters: 3757
Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass
Moderators: Paul (421), cnymike (8), sonika (95)
Administrators: Oliver (6400), Nicky (3)