Pqluglist- MySQL Error, was: Thanks everyone for subscribing

[Parksville-Qualicum Linux Users group mail list]

Looking at the structure and the query, I don't see any syntax errors or
mismatches between column types.  The only potential problem I can see is
that the log_id field is required, but it's not included in the query and
the table structure doesn't show that it is autoincremented as I would have
expected for a primary key.  If it's not set with the autoincrement
attribute, and the value isn't passed in the query, the query would fail.
You can check to see if it's auto incremented using phpmyadmin.

Ken

On Wed, Sep 16, 2009 at 10:47 AM, Parksville-Qualicum Linux Users group mail
list <pqluglist at pqlug.org> wrote:

> To post to this list, send email to: pqluglist at pqlug.org
>
> To unsubscribe or change your options (eg, switch to or from digest mode,
> etc.), go to: http://pqlug.org/mailman/options/pqluglist_pqlug.org
>
> or, via email, send a message with subject or body 'help' to:
> PQLUGlist-request at pqlug.org
>
> List archives at: http://pqlug.org/pipermail/pqluglist_pqlug.org/
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of pqluglist digest..."
> ---------------------------------------
> ---------------------------------------
>
> > Hi Alfred, the error message doesn't give the actual mysql error message,
> so
> > it's not that helpful.  Any chance you could post the structure of the
> > tiki_logs table?  I might be able to figure it out from that.  You'd get
> the
> > structure by using phpmyadmin or some such program to export the table
> > structure.
> >
> > Ken
> >
> Hi Ken, thanks for replying. The error started after I moved the web site
> and
> database to a new server, so I'm thinking I might just re-do the move and
> see if
> that fixes it. Here is the structure:
>
> tiki_logs
> Field   Type    Null    Default         Comments
> logId   int(8)  No
> logtype         varchar(20)     No
> logmessage      text    No
> loguser         varchar(40)     No
> logip   varchar(200)    Yes     NULL
> logclient       text    No
> logtime         int(14)         No
>
>
> Indexes:
> Keyname         Type    Cardinality     Field
> PRIMARY         PRIMARY         1       logId
> logtype         INDEX   1       logtype
>
>
> Space usage:
> Type    Usage
> Data    156     B
> Index   3,072   B
> Total   3,228   B
>                Row Statistics:
> Statements      Value
> Format  dynamic
> Rows    1
> Row length ø    156
> Row size  ø     3,228 B
> Creation        Sep 15, 2009 at 04:50 AM
> Last update     Sep 15, 2009 at 04:50 AM
> Last check      Sep 15, 2009 at 12:30 PM
>
>
> _______________________________________________
> PQLUGlist mailing list
> PQLUGlist at pqlug.org
> http://pqlug.org/mailman/listinfo/pqluglist_pqlug.org
> Visit our web site: http://www.pqlug.org
>