Post by anatho » Mon Dec 12, 2011 11:23 pm

I tried to make a test order (without registering, guest checkout). It works until step 5 (payment).

Then if I select paypal (step 5), next is

"I have read and agree to the Terms & Conditions"

I have selected this (put arrow), then if click on"Continue", the only thing I get is

"SyntaxError: Undefined Token".

Also it shows as "Message from Website"??? What is this????

Newbie

Posts

Joined
Wed Dec 07, 2011 6:55 am

Post by Qphoria » Mon Dec 12, 2011 11:42 pm

Get this patch to show the actual error:
http://forum.opencart.com/viewtopic.php?f=133&t=45863

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by anatho » Tue Dec 13, 2011 1:49 am

Ok, I did this now and it shows the actual error:

Image

What does this error mean?

Newbie

Posts

Joined
Wed Dec 07, 2011 6:55 am

Post by labeshops » Tue Dec 13, 2011 9:50 pm

Steps 3 and 4 deal with delivery information - step 3 is delivery address. Did you turn off the ship to an address other than billing? If so, this one may not show.

Step 4 is delivery options, so if you haven't set up any shipping methods, this might not show either. Haven't experienced either missing myself, so just a guess. (btw, you can always go look at the opencart demo store to see what the default should look like).

Did you do an upgrade or a fresh install? It looks like the last issue is a missing table, so if it was an upgrade, did you run the database upgrade script? Did you install any extensions or edit any files? I so, re-upload the base files you edited and see if you still have the same problems. If not, recheck your edits.

You can turn off the terms and conditions in your store settings until you figure that one out. Might also be a missing table.

Running Opencart v3.0.3.9 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by anatho » Tue Dec 13, 2011 10:07 pm

Hi

Referring to step 4, I have setup flat rate and free shipping as shipping methods. However, they are not shown.

Yes there is a missing table, however, it was no upgrade but a fresh install. But this is already the second error. First error was that I could not select any product in storefront, this has been solved already.

Also I turned off the terms&conditions now on checkout page, however, it still does not work. If you click on continue, you will get the same error as before.

Newbie

Posts

Joined
Wed Dec 07, 2011 6:55 am

Post by Qphoria » Thu Dec 15, 2011 5:49 am

Well the main issue here is the missing tax_rule table. Not sure how that can be missing if you ran the upgrade script. But try running it again. Get the installer folder from 1.5.1.3.1 zip file and upload it to your site
Then run yoursite.com/install and run the upgrade again. See if that fixes it

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by anatho » Thu Dec 15, 2011 8:39 am

Hi

I did not run the upgrade script before because it was a fresh installation.
If I run the upgrade script now, does that delete all my data (= products, terms&conditions, about us etc.)?
I did not delete the install order, so it is still on my webspace.
However, if I run this script, what does it delete?
Or is there any way to add this missing table manually?

Newbie

Posts

Joined
Wed Dec 07, 2011 6:55 am

Post by anatho » Sat Dec 24, 2011 2:06 am

What should be the effect of upgrading? I have version 1.5.1.3 and as far as I know it is the latest version. So upgrading to what???

This Europa version is full of errors, missing tables etc. and the guy who gave it out neither replies to pms nor seems to be active any longer on this forum

So I think I wasted my time and have to look for a new shop system. Standard oc is not of interest because I also need German language.

Newbie

Posts

Joined
Wed Dec 07, 2011 6:55 am

Post by itundmeer » Tue Jan 03, 2012 7:14 pm

I had similar issues with the European Installation:
Notice: Error: Table 'database.tax_rule' doesn't exist
Error No: 1146
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr1.priority ASC in /www/htdocs/xxxxxx/xxxxxx/system/database/mysql.php on line 49

after installation. I would recommend the default installation and go for single language packs in the extension directory.

Newbie

Posts

Joined
Mon Jan 02, 2012 11:58 pm
Who is online

Users browsing this forum: No registered users and 2 guests