Super Orders v3.0 Support Thread (for ZC v1.3.9)

[Centec2b]

Evening Diva, All,

Has any one experienced a 1061 error in connection with this contribution?

Quote
" 1064 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 's"

In essence the problem occurs if I try to use an apostrophe or quotation mark in the comments box EG

"Forum Do's and Dont's"

will be rejected, but

Forum Dos and Donts

will be accepted

There seem to be myriad occurrences of this error in the postings and many seem to indicate incompatible versions of o/s etc

I am running the most up to date version and the only change I have carried out has been the upgrade to ver3 super orders from 139. There has not been a problem using the previous setup

Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2010-12-26 23:01:36] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-06-01 15:31:20] (Fresh Installation)
PHP Version 5.2.14

I can also reproduce this issue on the test system which is running under xammp

Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
HTTP Server: Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
PHP Version: 5.2.9 (Zend: 2.2.0) PHP Memory Limit: 32M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M

Any guidance pointers thoughts gratefully recieved

A puzzled Centec2b!

[DivaVocals]

Already reported here:
http://www.zen-cart.com/forum/showth...=170525&page=3

Workaround for now is to not use quotes or single quotes in comments.. It will be included in the update I'm submitting this week..

Evening Diva, All,

Has any one experienced a 1061 error in connection with this contribution?

Quote
" 1064 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 's"

In essence the problem occurs if I try to use an apostrophe or quotation mark in the comments box EGwill be rejected, but will be accepted

There seem to be myriad occurrences of this error in the postings and many seem to indicate incompatible versions of o/s etc

I am running the most up to date version and the only change I have carried out has been the upgrade to ver3 super orders from 139. There has not been a problem using the previous setup

Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
v1.3.9h [2010-12-26 23:01:36] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2008-06-01 15:31:20] (Fresh Installation)
PHP Version 5.2.14

I can also reproduce this issue on the test system which is running under xammp

Zen Cart 1.3.9h
Database Patch Level: 1.3.9h
HTTP Server: Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9
PHP Version: 5.2.9 (Zend: 2.2.0) PHP Memory Limit: 32M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 64M POST Max Size: 64M

Any guidance pointers thoughts gratefully recieved

A puzzled Centec2b!

[Centec2b]

Already reported here:
http://www.zen-cart.com/forum/showth...=170525&page=3

Workaround for now is to not use quotes or single quotes in comments.. It will be included in the update I'm submitting this week..

ahhhhhh!
apologies did not see that

centec2b

[joyjoy]

Hi Diva! I've updated my Super Orders mod and it looks great!! Thank you for all of your hard work!

I have a quick question though. Each time I login to my admin if I make an update to the payment area I'm required to login in again. What happens is this:

I'll select the payment buttom, the pop up screen will appear with the normal information. When I submit I get the login screen (on the popup) I then close the popup, refresh my admin page and I'm logged out. Once I log back in I am able to complete the payment information.

Is this normal? If not, do you know how I would fix it? Thank you!

[DivaVocals]

Not normal at all.. might be a permissions issue.. Could be a sessions issue... I would double check that all the Super Orders file permissions are correct, and re-check your sessions settings..

I'll double check on my test store, but this has never happened in testing..

Hi Diva! I've updated my Super Orders mod and it looks great!! Thank you for all of your hard work!

I have a quick question though. Each time I login to my admin if I make an update to the payment area I'm required to login in again. What happens is this:

I'll select the payment buttom, the pop up screen will appear with the normal information. When I submit I get the login screen (on the popup) I then close the popup, refresh my admin page and I'm logged out. Once I log back in I am able to complete the payment information.

Is this normal? If not, do you know how I would fix it? Thank you!

[joyjoy]

This was going on before the upgrade too. It's not a big deal but it's frustrating when I'm in a rush. I'll check the permissions, I bet that's what it is.

Thank you!

[DivaVocals]

This was going on before the upgrade too. It's not a big deal but it's frustrating when I'm in a rush. I'll check the permissions, I bet that's what it is.

Thank you!

Then the issue is NOT a Super Orders issue.. Rather Super Orders is ILLUMINATING an existing issue..

Try this thread instead.. https://www.zen-cart.com/tutorials/i...hp?article=281

This might be the REAL issue you are experiencing.. If you need more assistance on it.. you know the drill.. Start a new thread.. BUT search before you do this.. I think there is a fair amount already posted on the forum on this matter..

Good luck.. Glad you like the NEW Super Orders.. You'll wanna upgrade when I submit v3.0.1 this week.. I tweaked quite a bit of stuff and fixed some buglets (see my post from yesterday) and Tony is gonna make some cool minor mods to the PDF packingslip so it will REALLY rock!!!

[DivaVocals]

ahhhhhh!
apologies did not see that

centec2b

No worries.. It was easy to miss this post..

[joyjoy]

Oh I'm not sure if I was clear on this. I was having to do this re-login thing before I upgraded to Super Orders 3.0. I don't experience this anywhere else in admin.

Do you think this is a zen cart issue then?

[DivaVocals]

Oh I'm not sure if I was clear on this. I was having to do this re-login thing before I upgraded to Super Orders 3.0. I don't experience this anywhere else in admin.

Do you think this is a zen cart issue then?

You were clear.. and I understood what you said.. Please see my previous responses as I did provide you some possible causes and a thread which might be the clue as to your REAL issue..