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

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 Dontswill 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!

Already reported here:
http://www.zen-cart.com/forum/showthread.php?t=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..

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!

DivaVocals:

Already reported here:
http://www.zen-cart.com/forum/showthread.php?t=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

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!

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..

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!

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!

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/index.php?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!!!

Centec2b:

ahhhhhh!
apologies did not see that

centec2bNo worries.. It was easy to miss this post.. :smile:

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?

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..

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?

If you are running 1.3.9h you may want to check to see if the
Debug Error Logging Utility is installed if not you can grab it here http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_54&products_id=860 this maybe a good way to start to see if any errors are popping up and give a good head start.

Hi,

I have just installed super orders 3.0 to my zencart 1.3.9h

However, after I uploading all files, my admin page becomes a blank page. The debug file said:
[09-Jan-2011 19:17:23] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /catalog/admin/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35

I tried to remove the lcsd_merged_packing_slips.php and the admin works again. Please let me know where the problem is. Thanks!

musicfreer:

Hi,

I have just installed super orders 3.0 to my zencart 1.3.9h

However, after I uploading all files, my admin page becomes a blank page. The debug file said:
[09-Jan-2011 19:17:23] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /catalog/admin/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35

I tried to remove the lcsd_merged_packing_slips.php and the admin works again. Please let me know where the problem is. Thanks!

Try reuploading the entire directory from the 1_Install_Files folder, see if this changes anything make sure you rename the directory YOUR_ADMIN

knuckle-101:

Try reuploading the entire directory from the 1_Install_Files folder, see if this changes anything make sure you rename the directory YOUR_ADMIN

Hi,

I have tried reuploading the whole folders again and again. And I also make sure that the admin directory has been changed.

By the way, I cannot find any folder names needed to change to my own template. Did I miss anything here?

musicfreer:

Hi,

I have just installed super orders 3.0 to my zencart 1.3.9h

However, after I uploading all files, my admin page becomes a blank page. The debug file said:
[09-Jan-2011 19:17:23] PHP Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /catalog/admin/includes/functions/extra_functions/lcsd_merged_packing_slips.php on line 35

I tried to remove the lcsd_merged_packing_slips.php and the admin works again. Please let me know where the problem is. Thanks!

On another note do you have Super Orders 2.0 installed before 3.0?

musicfreer:

Hi,

I have tried reuploading the whole folders again and again. And I also make sure that the admin directory has been changed.

By the way, I cannot find any folder names needed to change to my own template. Did I miss anything here?

Go to your admin --> tools --> Template Select what is the name of the template you are using.

Nevertheless there is no over ride needed for the Install and Required Core Files.

knuckle-101:

On another note do you have Super Orders 2.0 installed before 3.0?

I installed 2.0 in my old cart 1.3.8a

I am now building a new site 1.3.9h at another directory, but using the same database backup of the old website. I also believe this should be the problem, any idea how to fix it? thanks

knuckle-101:

Go to your admin --> tools --> Template Select what is the name of the template you are using.

Nevertheless there is no over ride needed for the Install and Required Core Files.

I am using a template called cherry_zen, but the point is as you said, I cant find any overrides needed. I think the problem is on the previous installation of 2.0

musicfreer:

I am using a template called cherry_zen, but the point is as you said, I cant find any overrides needed. I think the problem is on the previous installation of 2.0

Run this sql query file inside the Super Orders 3.0 folder uninstall_super_orders_prior_versions.sql using the admin install sql tool

admin --> tools --> Install SQL Patches use the browse and search button as it is more accurate then pasting

Once complete rerun the super_orders_install_v30.sql

knuckle-101:

Run this sql query file inside the Super Orders 3.0 folder uninstall_super_orders_prior_versions.sql using the admin install sql tool

admin --> tools --> Install SQL Patches use the browse and search button as it is more accurate then pasting

Once complete rerun the super_orders_install_v30.sql

I followed your steps, when I upload that file to the hosting, admin becomes blank again, any other possible reason?