Notifications
Clear all

SQL Error 1336 when using Anonymous Reviews and Logging.

3 Posts
2 Users
0 Reactions
2,617 Views
(@hobert)
Posts: 61
Trusted Member
Topic starter
 

eFiction archive:  http://www.hobert.net/fic
Version 3.3.1 upgraded from 3.3
Have you bridged eFiction, if so with what?: No
Server Type: Win 2003
Version of PHP: 5.2.4
Version of MySQL: 5.0.45
Have you searched for your problem: Yes
If so, what terms did you try: Anonymous review, SQL 1336, 1336
Have you looked at the FAQs: Yes.

Having fixed my "Captcha not matching" error on anonymous reviews, I now get a SQL error when adding one.

A fatal MySQL error was encountered.
Query: INSERT INTO fanfiction_log (`log_action`, `log_uid`, `log_ip`, `log_type`) VALUES('Test(66.243.97.144) wrote 'Test' as a review for 'A Day at the Beach'.', '', INET_ATON('66.243.97.144'), 'RE')
Error: (1366) Incorrect integer value: '' for column 'log_uid' at row 1

Turning off logging solves the error.


efiction - 3.5.3
MySql - 5.5.32
php - 5.5.22
Linex - Apache 2.2.17
Hosted by: Fatcow!
http://www.hobert.net/fic/

 
Posted : 08/10/2007 4:21 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

Can you please check and see if this is still an issue with 3.5? Thank you!


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 07/04/2009 2:25 am
(@hobert)
Posts: 61
Trusted Member
Topic starter
 

I turned on "Action Log" and submitting an anonymous review worked like it should (no error).  Don't remember if this was the "logging" I was talking about back then.

Thanks!


efiction - 3.5.3
MySql - 5.5.32
php - 5.5.22
Linex - Apache 2.2.17
Hosted by: Fatcow!
http://www.hobert.net/fic/

 
Posted : 07/04/2009 2:51 pm
Share: