Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Can't update site, SQL denied messages
Suddenly on my admin side I get this sort of messages:
Warning: UPDATE command denied to user ‘XXXXXXXX’ for table ‘txp_prefs’ update txp_prefs set val = ‘id’ where name like ‘image_sort_column’ AND user_name = ‘userX’ in /web/htdocs/www.boscartoon.com/home/textpattern/lib/txplib_db.php on line 89
Warning: UPDATE command denied to user ‘XXXXXXXX’ for table ‘txp_prefs’ update txp_prefs set val = ‘desc’ where name like ‘image_sort_dir’ AND user_name = ‘userX’ in /web/htdocs/www.boscartoon.com/home/textpattern/lib/txplib_db.php on line 89
whereas userX is my username and XXXXXXX is in the form of Sql00000’@‘00.00.00.00’ (sql number at domain).
Similar warning when i try to add an image, or an article, or to edit a table. Only, the command denied is INSERT instead of UPDATE.
This happened overnight on my site. Diagnostic is ok.
What can I try? Serious issue, if this would happen to a client site.
Thank you
Z
Offline
Re: Can't update site, SQL denied messages
Hi Zanza, Is your db OK also?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Can't update site, SQL denied messages
The db is there. The site is running, but I’m not sure it’s fully ok. From rss_db_admin I see that some table need repairing, but can’t do it from the plugin. I will try to enter mysql admin, but I’m not sure what kind of action i should start once there.
Any hint apreciated… :)
Offline
Re: Can't update site, SQL denied messages
Sorry I can not help you with commands but I’m sure somebody here will. If you have access to phpmyadmin, the actions to repair is straight forward.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Can't update site, SQL denied messages
Thanks Colak,
Definitely not a TXP problem! I’m talking with my hosting service, it seems it can’t get to recognize my username, password, recovery datas… not a good moment! :)
Bye
Offline