[ php-blog-Bugs-1462845 ] statistics plugin table creation error

Bugs item #1462845, was opened at 2006-04-01 23:58
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1462845&group_id=75065

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Plugins
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: MoMaT (momat)
Assigned to: Nobody/Anonymous (nobody)
Summary: statistics plugin table creation error

Initial Comment:
Since the upgrade to 1.1-alpha1, I see the error
messages  (see the attachment), complaining about
existence of some tables.

I tried to drop the tables to let the new version of
the plugin recreate them properly. However, they are
replaced by the old wrong ones by the next page hit. I
believe this is a bug in the plugin code.

----------------------------------------------------------------------

>Comment By: Garvin Hicking (garvinhicking)
Date: 2006-04-02 00:26

Message:
Logged In: YES 
user_id=473563

Hm, this might be a SQLite problem. When you drop the
tables, and they are created by the plugin again, is the
"counter_id" column missing?

Because in the plugin file I see no CREATE TABLE statement
that is omitting a "counter_id", so I wouldn't know why a
table without that item should be created?

Maybe you can try to manually create the table that is
listed in your error message and see if that yields an
error, or if it correctly then creates the "counter_id" column?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=1462845&group_id=75065


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642