Pqluglist- Thanks everyone for subscribing

[Parksville-Qualicum Linux Users group mail list]

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

On Tue, Sep 15, 2009 at 10:58 PM, Parksville-Qualicum Linux Users group mail
list <pqluglist at pqlug.brodiefamily.ca> wrote:

> To post to this list, send email to:
> pqluglist at pqlug.brodiefamily.ca
>
> To unsubscribe or change your options (eg, switch to or from digest mode,
> etc.), go to:
>
> http://pqlug.brodiefamily.ca/mailman/options/pqluglist_pqlug.brodiefamily.ca
>
> or, via email, send a message with subject or body 'help' to:
> PQLUGlist-request at pqlug.brodiefamily.ca
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of pqluglist digest..."
>
> I'm hoping this mail list will be a good way to keep in touch.
>
> To start it off, does anyone know anything about MySQL and or Tikiwiki? I
> get a
> SQL error when I try to log in to one of my web sites:
> http://www.alfredpratt.com
>
> An error occured in a database query!
>
> Context:
> File    tiki-logout.php
> Url     tiki-logout.php
> Query:
> insert into `tiki_logs`
> (`logtype`,`logmessage`,`loguser`,`logip`,`logclient`,`logtime`) values
> (?,?,?,?,?,?)
> Values:
> 0       login
> 1       logged out
> 2       admin
> 3       70.66.134.xx
> 4       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.14)
> Gecko/2009090216
> Ubuntu/9.04 (jaunty) Firefox/3.0.14
> 5       1253080581
> Message:
> Built query was probably:
> insert into `tiki_logs`
> (`logtype`,`logmessage`,`loguser`,`logip`,`logclient`,`logtime`) values
> ('login','logged out','admin','70.66.134.xx','Mozilla/5.0 (X11; U; Linux
> i686;
> en-US; rv:1.9.0.14) Gecko/2009090216 Ubuntu/9.04 (jaunty)
> Firefox/3.0.14','1253080581')
>
> Thanks
> Alfred
>
> _______________________________________________
> PQLUGlist mailing list
> PQLUGlist at pqlug.brodiefamily.ca
>
> http://pqlug.brodiefamily.ca/mailman/listinfo/pqluglist_pqlug.brodiefamily.ca
>



-- 
Ken Peters
Developer
http://www.canadacarbuyer.com
250-729-6639