same error again.
MySQL version 4.0.27-standard
Hope that helps, thanks
Oh, v4, that's quite old...
Sure it's the
exact same error?
I don't see how auto_increment could be specified anywhere...
Well, a dirtier fix is this:
In the file, search for:
TYPE=HEAP;
Replace with
TYPE=MyISAM;
I edited the last file you gave me with the 1 change.
Then deactivated the plugin.. then activated it again.
Then ran the Recount User Thread Counts again
Got this error again.
MySQL error: 1164
The used table type doesn't support AUTO_INCREMENT columns
Query: CREATE TABLE mybb_plaza_temp (`uid` int(10) unsigned auto_increment,`numtopics` int(10) unsigned, PRIMARY KEY (uid)) TYPE=HEAP;
wait, i got it... even thou i did the change, it did not take when i uploaded it to the server.
I made the code change on the server instead and it worked.
Thank you once again, this is a real gem to me.. a great plugin.
Ahh, you probably have resume enabled on your uploading app - try disabling it
Glad it works.