SMF Support > SMF 1.1.x Support
Error: "Unknown column 'add_deny' in 'field list'" when going to domain
codetrucker:
First off, Thank you for the help! I am very grateful this forum exists. :)
Secondly, I may have "built" my forum, but I am far from an "Admin" even though I wear the badge and all I know about "PHP" is how to (sometimes) check values in specific fields. I generally know my way around some syntax, but aside from checking values, I can not troubleshoot. I apologize in advance for my ignorance, especially in not being able to provide better starting information and will be happy to be you "eyes" and "ears." Please ask very specific questions and I will try to give specific answers, but I may have to ask you to explain your question too. Keep in mind it is a private family forum with a lot of personal discussions and information. I will not be able to provide a "guest" login, besides since the only thing I get when I try to go to the domain is an error I could not create a login if I wanted to.
My general issue arises from trying to migrate an old family forum database to a new SMF forum via BlueDomino's "Simple Scripts" SMF forum-building tool. The fact is I thought I had lost my forum over a year ago(?) and only yesterday got a clue it might be possible to restore it. I spent several hours with BlueDomino tech support and finally processed a ticket to send to the engineers. Here is the quote of their reply...
The wrong entry in Simple Scripts is fixed. Now the Simple Scripts shows the URL hxxp://www.tradesmantransport.com/ . Please check it.
Once the database is created, you cannot rename it. You need to create a new database.
Regarding to the issue with the website hxxp://www.tradesmantransport.com/ , the error 'Unknown column 'add_deny' in 'field list'' indicates that the issue is due to customization to the application or database. You need fix the issue from your end or you need to contact the application provider.
Frankly, I do not really understand all this and when I asked for a clarification they essentially sent the same message back. ??? I tried to go through the DB and delete the "add_deny" fields, but to no avail. Further, I compared it with the fields from another working forum I have and the "add_deny"
Error -> Unknown column 'add_deny' in 'field list'
Domain -> hxxp://www.tradesmantransport.com
Pointer -> My BlueDomino Pointing Manager is set to "Subdirectory" and that subdirectory is "/GFFforum"
I have exhausted my own ideas and searched the error on your forum with no results. So, where do we go from here?
[Note: I tried to post this with links for your convenience, but this was not allowed. If you cut/paste, you will need to correct the "hxxp" to "http", but I'll bet you knew that already. :)
K@:
If I was in your position, I think I'd say "Stuff it. Why not upgrade to the recent version?".
Depending on which version you're using, now, it would probably cure that error, at the same time. ;)
codetrucker:
--- Quote from: K@ on April 13, 2012, 04:09:04 PM ---
If I was in your position, I think I'd say "Stuff it. Why not upgrade to the recent version?".
Depending on which version you're using, now, it would probably cure that error, at the same time. ;)
--- End quote ---
I'm game and I am inclined to agree with you. I'm sure you know what you are talking about, but I don't understand. :-[ How can I update to the new forum if I can't even get in? ???
So, where do we go from here? By the way, I *DO* appreciate your help.
K@:
First off, which version do you currently have?
codetrucker:
Maybe I missed this part, but I did install a new forum with Simple Scripts and then imported the old database. I wonder if I need to install a 1.x forum, import and then upgrade? FYI - I understand the concept, but not the exact actions required.
Thoughts?
Navigation
[0] Message Index
[#] Next page
Go to full version