Quote:
Originally Posted by xTerMn8R
I had a lot of these types of problems with my hacks after upgrading from 3.01 to 3.03. How i fixed it was looked at the error and went into phpmyadmin and dropped and entries that continued to come up.(ie. in ur case here the "Usergroup" table 'shoutboxpermissions' entry
After finally getting rid of all the Table Modifications associated with the hack was I able to do fresh installs of the hacks... Its a time consuming process, but it works and can turn out to be less time consuming then other methods.
***Note*** Here's a tip .. If ya drop a table entry error and try and install the hack and it errors at a new point further along then the previous error spot then you'll probably need to drop BOTH table Mods again and so on and so forth for as many as there are. SO I just Copy and pasted them into a txt file and then I had the Hack Table Mods on file.
Good luck
|
Thanks, This did help alot, However the table additions that the install script errored on still have to be installed manually in order for the hack to work.
So If someone that is MYSQL talented could help us add these frases manually in th ADMINCP by properly wording and formatting the SQL table additions, this would be all that is left to get my clients Shout Box working.
Evething is showing on the page, but the Shot Box iss empty, I believe its due to PERMISSIONS, I cannot edit them in the ADMINPC because there is nothing under USERGROUPS, and it just happens that this is where the install script errored. I removed 2 table edits from the install script to get it to complete the install as instructed above.
Here is the installs table edits that I had to remove in order for the install script to complete.
ALTER TABLE . TABLE_PREFIX . usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions
and
"ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL, ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL",
I need these typed so I can cut and paste it into the ADMINCP's Execute SQL Query box.
This should add the Shout Box in my user groups, so I may change the permissions, so It can be viewed.
Am I making sense?? LOL