slik
07-19-2005, 02:50 PM
Hi
First post is out of necessity.
I am actually currently a forum user/moderator not admin yet. Though I am destined to be a software pro/developer due to current postgraduate studies, so the knowledge found in areas like this is going to become invaluable to me.
Anyway back on topic. VBulletin 3.0.7 and MySQL error 1054.
I have no access to the admin GUI but can get the access, just as soemone not exerienced in management of this software I am not claiming superhuman abilities or promising anythign to anyone.. But I am in the best position to learn quickly and help out with the solution.
Seems to be non universal across member base though, my own access is hampered by the inability to edit, others have no access at all as teh password column queried in their SQL is returning error. My editpost errors seem to be headed back to admin as
"mysql error: Unknown column 'forum.parentlist' in 'on clause'
mysql error number: 1054"
basic stuff really. I had read this can be due to too many open connections to the database confusing it and the server has reported to me a number of timed out requests on teh database but they did not indicate anything unusual. A solution perhaps upping the number of permitted connections?
The basic confusing thing is the non universal nature. Why would a SQL query I presume is the same for me loggin in as anyone else, work for me but not them. New users are gaining the same access as I am, and if it means anything I am one of the original registrations, many thousands ago. I know a bit of php and a enough SQL.
TIA guys and girls
First post is out of necessity.
I am actually currently a forum user/moderator not admin yet. Though I am destined to be a software pro/developer due to current postgraduate studies, so the knowledge found in areas like this is going to become invaluable to me.
Anyway back on topic. VBulletin 3.0.7 and MySQL error 1054.
I have no access to the admin GUI but can get the access, just as soemone not exerienced in management of this software I am not claiming superhuman abilities or promising anythign to anyone.. But I am in the best position to learn quickly and help out with the solution.
Seems to be non universal across member base though, my own access is hampered by the inability to edit, others have no access at all as teh password column queried in their SQL is returning error. My editpost errors seem to be headed back to admin as
"mysql error: Unknown column 'forum.parentlist' in 'on clause'
mysql error number: 1054"
basic stuff really. I had read this can be due to too many open connections to the database confusing it and the server has reported to me a number of timed out requests on teh database but they did not indicate anything unusual. A solution perhaps upping the number of permitted connections?
The basic confusing thing is the non universal nature. Why would a SQL query I presume is the same for me loggin in as anyone else, work for me but not them. New users are gaining the same access as I am, and if it means anything I am one of the original registrations, many thousands ago. I know a bit of php and a enough SQL.
TIA guys and girls
