Not logged in. · Lost password · Registration disabled
Forum: Overview Bugs / Fehler RSS
Error in SQL syntax upon subscription
Error after subscription confirmation
halinagold #1
Member since Oct 2007 · 4 posts · Location: halinagold
Group memberships: Mitglieder
Show profile · Link to this post
Subject: Error in SQL syntax upon subscription
Hi,
I just downloaded the post-notification plugin and am testing it. I subscribed successfully and received a confirmation email. When I get to the page where I'm to choose categoires I  get this error message:
Wordpress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1]
INSERT INTO wpf2_post_notification_cats (id, cat_id) VALUES (1, )

Any ideas what  this is about?

Thanks

Halina
Morty (Administrator) #2
User title: Author
Member since Jun 2007 · 928 posts
Group memberships: Administratoren, Mitglieder
Show profile · Link to this post
This is indeed a bit odd. Looks like once again one of those php works differently on every server problems. Can you give me your php and WP versions?
I'll try to fix it tonight, adding some extra checking.
halinagold #3
Member since Oct 2007 · 4 posts · Location: halinagold
Group memberships: Mitglieder
Show profile · Link to this post
That's a WP 2.2.2 and PHP 5 and mysql 4 on a windows server

Thank you!
Morty (Administrator) #4
User title: Author
Member since Jun 2007 · 928 posts
Group memberships: Administratoren, Mitglieder
Show profile · Link to this post
2.2.3 is a security update - but shouldn't be the problem.
halinagold #5
Member since Oct 2007 · 4 posts · Location: halinagold
Group memberships: Mitglieder
Show profile · Link to this post
This is a private blog so I don't upgrade each time.
I  also experienced severe problems with 2.3 so am kind of cautiaus right now...

Thanks
Morty (Administrator) #6
User title: Author
Member since Jun 2007 · 928 posts
Group memberships: Administratoren, Mitglieder
Show profile · Link to this post
Fixed. I'll release a fixed version tonight.
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum