Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Am i understanding you correctly that i should add one record to Store table?
And if that table stays empty, i might have problems?
it has 4 fields - store id, name, url, ssl
Do you know (or can help) what should be the right values for these fields? Or does it matter?
also what other Tables (that have foreign keys to table Store) i should update?
I am aware of SEO_URL table. Any other?
Thank you.
straightlight, I am having a similar issue with the new seo_url table. After converting from 2.0.3.2 to 3.0.3.2, I had to move all my data from the old url_alias table to the new seo_url table, as the upgrade dropped the ball. Populating the new table with the date from the old table was easy, using simple SQL commands. I have Use SEO Urls set to Yes in the store, but all products that I have added an SEO URL to, generate a 404 not found error when the browser tries to navigate to the SEO URL. Products without an SEO URL work just fine. Can navigate just fine to the products that don't have an SEO URL set in the product.straightlight wrote: ↑Sat Feb 22, 2020 3:31 amBy simply renaming the old table to your new table (or by copying the data via your new table) should not impact any losses unless you had an important mount of data where your browser may have expired the activity due to the data being too large to complete its process. This may vary between servers where settings may need to be adjusted by your host.
However, if you don't have a huge amount of data in your seo_url table, you should be able to retrieve those data accordingly unless the store_id and the language_id fields do not match your languages and store IDs you may have originally from the store. Ensure that all rows do match from each-other in order to see the results as expected in the OC admin. These queries can be launched easily from your PHPMyAdmin.
So, I checked that my .htaccess file (in the /store subdirectory of the site, where OpenCart is installed) has the following two lines:
RewriteEngine On
RewriteBase /store
All the data in the new seo_url table is populated correctly, with language_id=1 and store_id=0 in all rows. Here is an example of one of the INSERT statements that populated the new table (there are 408 total records in the table):
Code: Select all
INSERT INTO `oc_seo_url` (`seo_url_id`, `store_id`, `language_id`, `query`, `keyword`) VALUES
(5094, 0, 1, 'product_id=83', 'lumenier-qav-xs-bnf'),
You can see a real-world example by navigating to www.skyreadyrc.com. Click on the first product in the Featured tab (Cobra 5" Racing Frame), which has an SEO URL of "https://skyreadyrc.com/store/cobra-5-racing-frame.html". This generates a 404 not found error. Click the back button to return to the home page, then click on the second product in the Featured tab (Cobra Lite 5" Racing Frame). It finds the product page just fine (a NON-SEO URL of "https://skyreadyrc.com/store/index.php?route=product/product&product_id=332").
I tripled checked, and I DO have "Use SEO Urls" set to Yes for the store.
Any idea what is going wrong here with my SEO Urls?
Thank you very much for taking a look at this.
Reason: Added code tags and corrected my username.
Increase Your Child's I.Q.
iPad Wallpapers
Turtle & Tortoise Screen Savers
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
ELEV8TE Website Development
Available for hire - please contact me at https://www.elev8your.com/contact
https://www.elev8your.com
The reason why being is because there's no way to find out which SEO URL would be associated with the language ID accordingly when multiple language IDs are involved.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I didn't want to hijack this thread. That's one issue. There are many more issues with the opencart.sql file. I created a new, empty database and tried to import opencart.sql and it failed. It may be posted elsewhere or I can create a new topic but I have 0% confidence that an upgrade is running properly, even if you exclude the SEO URL issue.straightlight wrote: ↑Thu Apr 23, 2020 12:48 amThe reason why being is because there's no way to find out which SEO URL would be associated with the language ID accordingly when multiple language IDs are involved.
ELEV8TE Website Development
Available for hire - please contact me at https://www.elev8your.com/contact
https://www.elev8your.com
Excluding the seo_url table will not fail the upgrade since this table is not included in the upgrade script due to the reasons I have explained above. There's no need to create a new topic about the same issue. However, if you'd like me to run the upgrade for you, send me a PM and I could complete the process for you as a custom job.Elevate wrote: ↑Thu Apr 23, 2020 1:56 amI didn't want to hijack this thread. That's one issue. There are many more issues with the opencart.sql file. I created a new, empty database and tried to import opencart.sql and it failed. It may be posted elsewhere or I can create a new topic but I have 0% confidence that an upgrade is running properly, even if you exclude the SEO URL issue.straightlight wrote: ↑Thu Apr 23, 2020 12:48 amThe reason why being is because there's no way to find out which SEO URL would be associated with the language ID accordingly when multiple language IDs are involved.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I appreciate the offer but I've already run the upgrade. It misses everything in the events table. I'm still exploring to see what else is missing.straightlight wrote: ↑Thu Apr 23, 2020 2:03 amExcluding the seo_url table will not fail the upgrade since this table is not included in the upgrade script due to the reasons I have explained above. There's no need to create a new topic about the same issue. However, if you'd like me to run the upgrade for you, send me a PM and I could complete the process for you as a custom job.Elevate wrote: ↑Thu Apr 23, 2020 1:56 amI didn't want to hijack this thread. That's one issue. There are many more issues with the opencart.sql file. I created a new, empty database and tried to import opencart.sql and it failed. It may be posted elsewhere or I can create a new topic but I have 0% confidence that an upgrade is running properly, even if you exclude the SEO URL issue.straightlight wrote: ↑Thu Apr 23, 2020 12:48 am
The reason why being is because there's no way to find out which SEO URL would be associated with the language ID accordingly when multiple language IDs are involved.
Open up the opencart.sql file and take a look at the queries for the events table. It's missing sort orders so it fails.
To clarify, the upgrade doesn't produce an error message anywhere. It simply doesn't add the events to the table during the upgrade process.
ELEV8TE Website Development
Available for hire - please contact me at https://www.elev8your.com/contact
https://www.elev8your.com
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Just take a quick look at the data there and you will see what I'm talking about. It's quite obvious what is wrong with it.straightlight wrote: ↑Thu Apr 23, 2020 2:37 amRe-run the SQL query for the oc_event table from PHPMyAdmin and see if that rectifies the issue. Ensure that your database table prefix name also matches with the query you're pasting in the SQL tab of your Opencart database prior on running the query.
ELEV8TE Website Development
Available for hire - please contact me at https://www.elev8your.com/contact
https://www.elev8your.com
Depending on the OC version you're using, see this solution for OC v3.0.2.0 release: viewtopic.php?f=19&t=213184&p=761969#p761969 .Elevate wrote: ↑Thu Apr 23, 2020 3:56 amJust take a quick look at the data there and you will see what I'm talking about. It's quite obvious what is wrong with it.straightlight wrote: ↑Thu Apr 23, 2020 2:37 amRe-run the SQL query for the oc_event table from PHPMyAdmin and see if that rectifies the issue. Ensure that your database table prefix name also matches with the query you're pasting in the SQL tab of your Opencart database prior on running the query.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
That helps. It's an upgrade from 2.3.0.2 to 3.0.2.0straightlight wrote: ↑Thu Apr 23, 2020 4:02 amDepending on the OC version you're using, see this solution for OC v3.0.2.0 release: viewtopic.php?f=19&t=213184&p=761969#p761969 .Elevate wrote: ↑Thu Apr 23, 2020 3:56 amJust take a quick look at the data there and you will see what I'm talking about. It's quite obvious what is wrong with it.straightlight wrote: ↑Thu Apr 23, 2020 2:37 amRe-run the SQL query for the oc_event table from PHPMyAdmin and see if that rectifies the issue. Ensure that your database table prefix name also matches with the query you're pasting in the SQL tab of your Opencart database prior on running the query.
I will probably look over the entire opencart.sql file because I have a feeling more is missing now.
ELEV8TE Website Development
Available for hire - please contact me at https://www.elev8your.com/contact
https://www.elev8your.com
This 1 line SQL totally fixed the issue. I had upgraded from 2.3.0.2 and noticed all ym seo urls were gone (3400). All back with that one command.como wrote: ↑Tue Jan 15, 2019 1:02 amHere I like to publish my more general and simple solutin.
You should run just one MySQL line:
Code: Select all
INSERT INTO `oc_seo_url` (`language_id`, `query`, `keyword`) SELECT 1 AS `language_id`, `query`, `keyword` FROM `oc_url_alias`
Self Taught Opencart User & Developer Since 2010.
Attachments
export.jpg (72.22 KiB) Viewed 1477 times
import.jpg (72.52 KiB) Viewed 1477 times
Users browsing this forum: No registered users and 220 guests