Accidently deleted Categories module, cannot reinstall

[The Lego Man]

Hi All,

 

Unfortunately when adding a new module in the Admin interface, I have deleted the Categories module. I went to reinstall it but have been greeted by the following error messages (in Admin/which I have no idea how to remedy.

 

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/mm/public_html/(website url)/admin/modules.php on line 227

Warning: Variable passed to each() is not an array or object in /home/mm/public_html/(website url)/admin/modules.php on line 228

 

Any help greatly appreciated as now I have a store live with no categories visible.

[The Lego Man]

I've now managed to delete the Search module; Admin now shows "Install Modules (2)" - these are the deleted Categories and Search modules. However, when I click on Install Modules and select either Categories or Search the error message above is shown.

 

Having clicked on Install Modules, if I select the Search module and click Edit it will edit not the Search module but the Best Sellers module. If I select the Search module and then Remove Module I suspect that it will remove the Best Sellers module and not the Search module.

 

I am using OSC v 2.3.1.

 

Is there any information I can provide that may help solve the problem? It appears the same issue was encoutered by 2 users (see http://www.oscommerce.com/forums/topic/378890-warning-passed-variable-is-not-an-array-or-object/ ) but no solution posted :(

[Bob Terveuren]

Hi I'm mystified by the 2.3.x boxes modules stuff so treat this with suspicion ... (but it worked for me) .... so backup the table first

 

If you go to your database there's an entry in the configuration table MODULE_BOXES_INSTALLED - delete any values in there but keep the entry

Now do a wildcard search for CONFIGURATION_KEY %LIKE% MODULE_BOXES and delete all the entries other than MODULES_BOXES_INSTALLED

 

Now go to the admin modules boxes page (make sure there's no &action=xxx left in the url and you should be able to start reinstalling them from scratch

[The Lego Man]

Bob,

 

That's a great help, many thanks! I have been able to reinstall all the modules. The only issue now appears to be that the Sort Order isn't fully working (ie when I number them 1,2,3,4, etc, some of the modules don't order themselves as they should). Any ideas would be very welcome.

 

Again, thanks for the huge help!

[The Lego Man]

No problems now - found the issue; the sort order numbering should be in the 1000 or 5000 ranges. I had used numbers 1 to 20 which seemed to cause the issue, as once replaced by these higher numbers has solved the problem.