I took a modual from the shopping cart I am used and hacked it so that it would be a different named file, but still function the same way.
Here is a copy of the error I am getting.
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_order
Now the words I changed were "FAQ" and "Topic"
FAQ is the type of Thing it was
And Topic is how it was stored.
My issue was that I changed all the FAQ to HELM, and it worked fine except that It wouldnt go to my pages that I was creating in the admin section. It always redirected it to the "FAQ" section instead.
This happened because the word "Topic" was active in both the FAQ and the HELM sections confusing the database.
I changed the word "Topic" to "Manual" in the coding for the "Helm" section.
This is so that the "Helm" and the "Faq" section do not equal to the "FAQ" section alone.
By changing the "Topic" to "Manual" this disassociates the 2 tables.
Now I am getting an error in the above message.
Im wondering what I can do to fix this. Should I change the 1 to a 2?
Do I have to add anything else to pre-existing tables?