Re: Super Orders v3.0 Support Thread
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
Quote:
"Forum Do's and Dont's"
will be rejected, but
Quote:
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!
Re: Super Orders v3.0 Support Thread
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..
Quote:
Originally Posted by
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 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!
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
ahhhhhh!
apologies did not see that
centec2b
Re: Super Orders v3.0 Support Thread
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!
Re: Super Orders v3.0 Support Thread
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..
Quote:
Originally Posted by
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!
Re: Super Orders v3.0 Support Thread
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!
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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!
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..:laugh: 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!!!
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
Centec2b
ahhhhhh!
apologies did not see that
centec2b
No worries.. It was easy to miss this post.. :smile:
Re: Super Orders v3.0 Support Thread
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?
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
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?
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..
