Could not execute SQL query" DROP TABLE IF EXISTS `SimpleCMS
|
Lisa |
2008-04-16 16:02:24 |
I'm getting an error "after" I've made the changes to the install files according to mysql settings for both Simple CMS and Contact Form Generator. Is there a suggestion that may help correct this?
|
Veselin |
2008-04-16 20:33:21 |
this means that MySQL username you use does not have full privileges. Please make sure it has DROP privilege too.
|
Lisa |
2008-04-17 00:33:13 |
You'll have to forgive me, I'm new at MySQL, so I'm working on this, but I did get this new warning when trying to change my privilege. I'm looking into "how to" run the script and where to find it.
But I could use direction if you have time?
Warning: Your privilege table structure seem to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!
|
Veselin |
2008-04-17 10:03:09 |
I believe you see this error message using your hosting account tools and not our script, don't you? I would suggest that you contact your hosting company and ask them to set full priveleges to your MySQL user OR please send me FTP login details (via email) and I will modify the installation script and try to install it.
|
LIsa |
2008-04-17 13:00:11 |
You're correct, sorry I should have made that clear, it IS NOT your script, yet Yahoo! MySQL that's giving me that warning. I think I can figure it out if I can just find the script, and that may be superseded in an upgrade I have to do. I'll contact them and see if this can be fixed. It seems I should have full privileges to begin with! lol I'll come back and let you know.
|
Lisa |
2008-04-18 05:37:28 |
request "Unable to connect to MySQL server."Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)
It said I successfully installed SimpleCMS, but when I click on the admin page, this is the error I get above.
I think correcting this last part will do it!
|
Veselin |
2008-04-18 09:44:16 |
this means that MySQL login details in your options file are incorrect. Are you sure that installation file was successfully executed? I can install the script for you if you send me login details for your hosting account control panel - please send them via email and do not post them here !
|
Lisa |
2008-04-18 13:37:07 |
Both scripts SimpleCMS and the contact form generator said they were both successfully installed.
Two problems now:
1) Contact Generator once I take the HTML out and put it in my site, (nothing changed) I get "failure" on the page it should redirect to after filling out the form.
2) for the Simple CMS: request "Unable to connect to MySQL server."Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)
I'm in contact with Yahoo! at the moment about my privileges - I seem to have them set to all which includes DROP.
After I figured out how to do that (with no help from Yahoo - in fact they told me in myPHPadmin, I couldn't have those privileges), I think I have it all changed right.
Once that was done the two scripts you have, seemed to install successfully per the message. I didn't get any error message that time around when installing.
I'm 100% sure this is not a script problem on your end for sure.
I think this is a Yahoo! issue. Before I purchased the scripts from you I made sure I had access to sql, php and all of that.
I guess Yahoo! hosting stinks when it comes to mysql! lol
I'm on the phone "again" with them now to see if any of this can be fixed. My guess is it won't be from their end.
What email address should I contact you at if I choose to allow for your help?
Also, what info do you need besides the c-panel info.?
Thanks and I'm really sorry to be such a pain about this.
|
Veselin |
2008-04-18 13:39:54 |
you can send us control panel login details to info- at -phpjabbers -dot- com
|
Lisa |
2008-04-18 13:57:28 |
Just emailed it to you.
|
Lisa |
2008-04-24 14:00:43 |
Thanks for fixing this :)