"Cannot execute this query" alert appears

Rhubarbare

(@rhubarbare)

Posts: 3

New Member

Topic starter

Wordpress says:

Oops, there has been a problem when upgrading Xhanch - My Twitter
Cannot execute this query:
alter table wp_xmt add las_twt_imp_dtp bigint(20) not null after prf_cch_dtp

and the plugin is not dsplayed anymore on the blog page.

Ideas?

Posted : 16/06/2011 8:22 pm

XHanch

(@xhanch-alt)

Posts: 2105

Member Admin

Well, actually, that's not what WordPress's says. It's a message from Xhanch - My Twitter installer system.

As you can see, the installer failed to execute that query.
So, try to run that query via PHPMyAdmin and you should find out why the query cannot be run

alter table wp_xmt add las_twt_imp_dtp bigint(20) not null after prf_cch_dtp

Or, you can install this plugin
http://wordpress.org/extend/plugins/xhanch-my-advanced-settings/
On Xhanch -> My Adv. Settings, turn on (check) the Show SQL errors.
With this setting on, you should find a more specific message that show why that query failed to run on your server.
As you see that, post that message here.

Posted : 16/06/2011 9:49 pm

Rhubarbare

(@rhubarbare)

Posts: 3

New Member

Topic starter

Thanks for looking into this. here is what I get after installing Advanced Settings:

WordPress database error:

select nme from wp_xmt_acc order by nme

WordPress database error: [Access denied for user 'yscr_bbtJQ2'@'localhost' to database 'blog']
alter table wp_xmt add las_twt_imp_dtp bigint(20) not null after prf_cch_dtp

My hosting service is Yahoo.

Posted : 16/06/2011 10:29 pm

XHanch

(@xhanch-alt)

Posts: 2105

Member Admin

WordPress database error:

select nme from wp_xmt_acc order by nme

WordPress database error: [Access denied for user 'yscr_bbtJQ2'@'localhost' to database 'blog']
alter table wp_xmt add las_twt_imp_dtp bigint(20) not null after prf_cch_dtp

The first message occurs because the installation/upgrade cannot be completed.

The second message shows the reason why the installer failed to run the query. This message indicates that there is a permission issue with your MySQL. Please make sure that you have granted all permissions to yscr_bbtJQ2 user so it can modify an existing table. If you are not sure about how to do this, you may contact your hosting support and let them read this topic/thread.

Posted : 16/06/2011 10:44 pm

Rhubarbare

(@rhubarbare)

Posts: 3

New Member

Topic starter

The situation has gone from bad to worse. I cannot access the login page anymore and get this message:

WordPress database error:

select nme from wp_xmt_acc order by nme

WordPress database error: [Duplicate column name 'las_twt_imp_dtp']
alter table wp_xmt add las_twt_imp_dtp bigint(20) not null after prf_cch_dtp

I contacted Yahoo (hosting) and wordpress support, but no action on their part. The blog itself is still accessible in view mode but displays at the top of the page this message:

WordPress database error:

select nme from wp_xmt_acc order by nme

No idea what to do...

Posted : 19/06/2011 6:06 pm

XHanch

(@xhanch-alt)

Posts: 2105

Member Admin