Post by conny31 » Wed May 23, 2012 5:31 am

I keep receiving the following error message when in the checkout process "SyntaxError:JSON.parse:unexpected character". I checked out the Trouble shooting section and used Firebug which shows me the following error message:

<b>Notice</b>: Error: Unknown column 'reward' in 'field list'<br />Error No: 1054<br /> .... in system/database/mysql.php</b> on line <b>49</b>

I have tried everything to find it but can't seem to figure it out... can anyone help me? ??? It's a fresh open cart installation with europe language extension package.
Last edited by conny31 on Thu Jul 05, 2012 6:46 am, edited 1 time in total.

Newbie

Posts

Joined
Wed May 23, 2012 4:51 am

Post by bingo » Wed May 23, 2012 1:19 pm

Before opencart 1.5.2,reward field in mysql database order table.
After opencart 1.5.1.3,reward fields in mysql database order_product table.

Check which version you use.

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by ranipak » Wed May 23, 2012 11:42 pm

I get the same error here. opencart 1.5.1.3
How do we correct this error? Need help!

Newbie

Posts

Joined
Wed May 23, 2012 11:40 pm

Post by Avvici » Wed May 23, 2012 11:54 pm

Send a link to your website please.

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by ranipak » Thu May 24, 2012 12:41 am

www.ranipak.com

thanks in advance for the help

Newbie

Posts

Joined
Wed May 23, 2012 11:40 pm

Post by Avvici » Thu May 24, 2012 2:21 am

I see the error and where it's popping up. If someone doesn't get to it soon I will later. I have to sign off for a while. You can reach my on my Skype if you want at Involution Media

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by conny31 » Thu May 24, 2012 2:55 am

bingo wrote:Before opencart 1.5.2,reward field in mysql database order table.
After opencart 1.5.1.3,reward fields in mysql database order_product table.

Check which version you use.
How can I solve this? In which file can I check and change the command? My website is http://moringa-bio.com/shop

Newbie

Posts

Joined
Wed May 23, 2012 4:51 am

Post by bingo » Thu May 24, 2012 3:19 am

Both of you guys using 1.5.1.3
Back up mysql database before you do this.

login myphpadmin,
add reward filed to order table
sql query will be:
ALTER TABLE `order` ADD `reward` int(8) NOT NULL

check tabel order_product,if exiested reward field,delete it.

It should solve the problem.

bingo

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by ranipak » Thu May 24, 2012 4:40 am

@bingo,

Your instructions worked great!
Thank you so much

Newbie

Posts

Joined
Wed May 23, 2012 11:40 pm

Post by conny31 » Thu May 24, 2012 6:04 am

@bingo,

Thanks so much it worked perfectly!!! What great support, definitely a life saver!!

Newbie

Posts

Joined
Wed May 23, 2012 4:51 am

Post by linhos » Thu Jun 07, 2012 9:19 am

Hello bingo, I'm with this problem SyntaxError: JSON.parse: unexpected character in step 5 of my payment OpenCart(1.5.3,1), and takes a lot of resolve this, so I do not understand very well I do in q mysql to make the change that you suggested, so I wonder if you can let me explain in more detail WHAT I do to solve my problem with this error. my website is Http follows: bethapecas.com.br, thank you very much for your help forum. Success to all!

Newbie

Posts

Joined
Thu Jun 07, 2012 9:12 am

Post by bingo » Thu Jun 07, 2012 10:37 am

When I test your website,the index give the following errors:
Notice: Error: Table 'bethapec_300882.oc_store' doesn't exist
Error No: 1146
SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://bethapecas.com.br/' in /home/bethapec/public_html/system/database/mysql.php on line 49

One Page Checkout Professional - More flexible and powerful one page checkout solution.
One Page Checkout Standard - Best one page checkout solution,separate module,no core files replace.
Product Import Export - Bulk insert update download product excel format.
Order Manager - help you manage orders more effectively.


User avatar
Active Member

Posts

Joined
Sun Sep 04, 2011 6:57 am


Post by mcspirit » Wed Dec 12, 2012 7:34 am

bingo wrote:When I test your website,the index give the following errors:
Notice: Error: Table 'bethapec_300882.oc_store' doesn't exist
Error No: 1146
SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://bethapecas.com.br/' in /home/bethapec/public_html/system/database/mysql.php on line 49
I get this on my store to????

Newbie

Posts

Joined
Wed Dec 12, 2012 6:56 am

Post by Xonnie316 » Sun Jul 14, 2013 10:02 am

Thanks @bingo for your instructions. You fixed my problem!

User avatar
New member

Posts

Joined
Fri Mar 16, 2012 7:19 am
Location - Melbourne, Australia
Who is online

Users browsing this forum: No registered users and 78 guests