So I have the FAQ mod, and I hacked it to read differently.
I have a FAQ section and I have a second section with the same frame work. On the second section I went and changed every word that read "FAQ, faq, and Faq" to its appropriate name case sensitive.
Now it works on the admin side, and partially on the Catalog side.
When you click on the icon on the menu it takes you to the new section. The link on there that is supposed to take you to xxx page is there. But its link is to some random page in the original FAQ section.
Ive checked my entries into the admin files, and they all check out fine. Every word has been changed correctly, etc. So why does it go to a random original FAQ question?
Its like the database isnt storing the new FAQ pages Im creating.
http://www.axidworks.com/index.php?rout ... ation/helm
My best guess here is that the section I want to create isnt creating its own database table to store the new web pages at.
But in theory here if I change every single FAQ entry in the upload folder to HELM it should create a database table for the HELM section instead of FAQ.
Unless the database table for the FAQ has a unique name that isnt labled "FAQ" and is called something else that Im not changing. Im guessing that should be in the admin/controller section of the upload form.
But in theory here if I change every single FAQ entry in the upload folder to HELM it should create a database table for the HELM section instead of FAQ.
Unless the database table for the FAQ has a unique name that isnt labled "FAQ" and is called something else that Im not changing. Im guessing that should be in the admin/controller section of the upload form.
Looking closer into this I downloaded my database and found the table for the helms section
This is the only place that I found the helms table.
Now what Im thinking, is because the FAQ section is described as information/FAQ, the helm table is described as information/helm
I think it may be, because the Helm and FAQ both have the same prefix that it is not working correctly. Is anyone following what Im saying?
So If I go into the root HELM mod and change all the "information" words to a different word, like "manual" so that it would read "manual/helm"
Make sense I dont really know what Im doing here, just guessing, but I do want this section to work
Code: Select all
TRUNCATE TABLE `helm`;
INSERT INTO `helm` (`helm_id`, `topic_id`, `status`, `sort_order`) VALUES ('3', '0', '1', '1');
TRUNCATE TABLE `helm_description`;
INSERT INTO `helm_description` (`helm_id`, `language_id`, `title`, `description`) VALUES ('3', '1', 'Honda Prelude 92-95 H22, H23, F22 PDF File', '<p>\r\n\tThis is the complete Helm Inc Manual for the 92-95 Honda Prelude. Its for use free of charge. </p>\r\n<p>\r\n\t </p>\r\n<p>\r\n\t<a href="http://www.axidworks.com/h22helms.pdf">H22 Prelude PDF Helm File <br />\r\n\t</a></p>\r\n<p>\r\n\t </p>\r\n<p>\r\n\tPlease wait for it to load, it is a large file, depending on your internet connection it may take a few minutes.</p>\r\n');
TRUNCATE TABLE `helms`;
INSERT INTO `helms` (`helms_id`, `topic_id`, `status`, `sort_order`) VALUES ('1', '0', '1', '1');
TRUNCATE TABLE `helms_description`;
INSERT INTO `helms_description` (`helms_id`, `language_id`, `title`, `description`) VALUES ('1', '1', 'H22 Honda Prelude 92-95 Manual', '<p>\r\n\tTest link to Helms</p>\r\n');
Now what Im thinking, is because the FAQ section is described as information/FAQ, the helm table is described as information/helm
I think it may be, because the Helm and FAQ both have the same prefix that it is not working correctly. Is anyone following what Im saying?
So If I go into the root HELM mod and change all the "information" words to a different word, like "manual" so that it would read "manual/helm"
Make sense I dont really know what Im doing here, just guessing, but I do want this section to work
you don't want to do that. the information is only talking about what subfolder the files are in meaning your files are in catalog/controller/information/helm.php etc.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Thanks, I figured that out after posting.
I think I found the error.
If you look closely there are two different tables there.
One is called "HELM" and the other is called "HELMS"
I originally wrote the first try as HELMS but deleted it because the "S" was messing things up. So I did a new one called "HELM" with out the "S".
Now all the uploads I do, as going to the "HELMS" folder instead of the "HELM" database.
I only have an active database for the "HELM" file and not the "HELMS"
For some reason, its uploading the "HELMS" instead of the "HELM" database.
I tried to cut out both parts of the database, and upload into the restore and it gave me an error.
What do I need to get that out of my database for good, and than reinstall it again, and everything should go right this time.
I think I found the error.
If you look closely there are two different tables there.
One is called "HELM" and the other is called "HELMS"
I originally wrote the first try as HELMS but deleted it because the "S" was messing things up. So I did a new one called "HELM" with out the "S".
Now all the uploads I do, as going to the "HELMS" folder instead of the "HELM" database.
I only have an active database for the "HELM" file and not the "HELMS"
For some reason, its uploading the "HELMS" instead of the "HELM" database.
I tried to cut out both parts of the database, and upload into the restore and it gave me an error.
What do I need to get that out of my database for good, and than reinstall it again, and everything should go right this time.
You're still going to have problems. You'll need to change the field named "topic_id" in your helm (or helms) table to something else (like "manual_id"), otherwise you'll have conflicts with SEO URLs.
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool
If you're not living on the edge ... you're taking up too much space!
Ok so I did that and got this error
Where is this column located at.
Is it not recognizing the word "manual" and it needs to be fixed somewhere else?
Code: Select all
Error: Unknown column 'f.manual_id' in 'where clause'
Error No: 1054
SELECT * FROM helm f LEFT JOIN helm_description fd ON (f.helm_id = fd.helm_id) WHERE f.manual_id = '0' AND fd.language_id = '1' AND f.status = '1' ORDER BY f.sort_orderWhere is this column located at.
Is it not recognizing the word "manual" and it needs to be fixed somewhere else?
I got it. I dont know what the issue was but I think having both helms and helm in the data base confused it.
Who is online
Users browsing this forum: No registered users and 18 guests
