ALTER TABLE error on every page of my blog

WassUp Forums » WassUp Support

ALTER TABLE error on every page of my blog

(8 posts) (2 voices)

Started 4 years ago by geraldomagellajunior
Latest reply from geraldomagellajunior

Tags:

geraldomagellajunior
Member

Hi people, I'm having a bit of a trouble get this plugin up and running, can anyone Help-me? Every page on my blog has this message:

WordPress database error Duplicate column name 'timestamp' for query ALTER TABLE wpgeraldo_wassup ADD COLUMN timestamp varchar(20) default NULL WordPress database error Duplicate column name 'language' for query ALTER TABLE wpgeraldo_wassup ADD COLUMN language varchar(5) default NULL

I Already tried to drop these columns and the error desapears only for one page view, and then it continues to appear. Does anyone now about it?

Posted 4 years ago #
Michele
Key Master

Hi,
what WassUp and Wordpress version do you use? Is it a fresh WassUp installation or did you try an upgrade?
Thank you

Michele - WassUp Project

Posted 4 years ago #
geraldomagellajunior
Member

It was a fresh install of wassup 1.4.3 on WP 2.3.2.
URL geraldo.inventta.com.br
Thank you!

Posted 4 years ago #
Michele
Key Master

Please could you try to overwrite your wassup.php file with this: http://trac.wpwp.org/browser/trunk/wassup.php?format=raw
The best approach should be:

1) disable WassUp plugin
2) drop the wpgeraldo_wassup table from your Wordpress database
3) overwrite the file wassup.php
4) enable the plugin

Please let me know

P.S.
if you experience the problem again, please I need your mysql version

Posted 4 years ago #
geraldomagellajunior
Member

Thank you for your time and patience! I apreciate it!

I'm a web developer (not familiar with php, I work with asp e .NET) but could notice what you changed (and it worked, by the way).

* You have changed JQuery (last parameter) to 1.2.1 (before was: 1.2.2).
* Some statistics were excluded, like lines: 634, 639 and 643.
* Some other minor changes.
* Added the "`" character to the timestamp and language on the CreateTable function.
* Removed some spiders identification on wGetSpider function.

I supposed that you gave my some edited version to troubleshooting, is that right? In that case I can tell you that worked. Wordpress plug-in page tells me that "There is a new version of WassUp".

What should I do? Continuing to use this edited version or I can use another one?
Thank you again for your kindness in anwser my questions.

Posted 4 years ago #
geraldomagellajunior
Member

Sorry, forgot to tell, my MySQL is version 4.1.18-nt.
Thanks

Posted 4 years ago #
Michele
Key Master

I'm happy it works! Yes I gave you a modified version which will be the next release (1.4.4).

Your WP tells you there is an upgrade because the version you are using now is 1.4.3a is different from the actual 1.4.3, please don't touch it before you see the 1.4.4 version available at http://wordpress.org/extend/plugins/wassup/

Thank you for the report

Posted 4 years ago #
geraldomagellajunior
Member

That´s great! Keep up the great work! (When I grow up, I would like to be like you guys! :) LOL )
Thank you, again, for your time, i'm very satisfied!

Posted 4 years ago #

RSS feed for this topic

Reply

You must log in to post.