M
Mike Welch
Guest
I have installed this script, and it looks great. Only problem so far is that if I don't have a unique table (usually uid for user id), then it works fine, I can insert records. However, of course, I cannot edit or delete them. When I do have a unique table (again, uid), it won't add records, gives me this error:
Error during query execution.
select user_I from test1
MySQL server said: Unknown column 'ui' in 'field list'
So, I tried some stuff, same thing, reset everything, tried again, this time renaming the uid field as user_ID. Then, here's what I got:
Error during query execution.
select user_I from test1
MySQL server said: Unknown column 'user_I' in 'field list'
It seems that it's taking the last letter of my unique field and removing it for some reason, thereby causing an internal conflict. Just so you know, both times, I had the uid/user_ID field set to auto-increment.
Error during query execution.
select user_I from test1
MySQL server said: Unknown column 'ui' in 'field list'
So, I tried some stuff, same thing, reset everything, tried again, this time renaming the uid field as user_ID. Then, here's what I got:
Error during query execution.
select user_I from test1
MySQL server said: Unknown column 'user_I' in 'field list'
It seems that it's taking the last letter of my unique field and removing it for some reason, thereby causing an internal conflict. Just so you know, both times, I had the uid/user_ID field set to auto-increment.