Da store is griefin me!

Store screwed up after the upgrade. Uninstalled it and tried to reinstall it. Getting the following error.

Installation of: Store Failed

INSERT INTO `sys_menu_top` VALUES(NULL, 4, 'Store', '_bx_store_menu_my_products_profile', 'modules/?r=store/browse/my', @iCatProfileOrder, 'memb', '', '', '', 1, 1, 1, 'custom', '', '', 0, '');

didn't work

Ok, what the FUDGE am I sposed to do with that?

and out of curiosity, what happened to the stuff that was already there? I had store working before the upgrade.

Run it, I think.

That's my guess too but that's a LOT to stuff in that little query box, lol

nothing just look at it hahahah j/k  run the sql query in phpmyadmin it should install the module :) or just replace the install folder with 7.0.1 original files and try it in admin section to install

if you uninstalled it it's gone :)

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `[db_prefix]customers` ( `file_id` int(10) unsigned ' at line 30

........... wtf.......... LOL 
option B download 7.0.1 full and replace the store module if your site breaks down you didn't get this from me i don't know you you don't know me

 I beat ya to the punch. I uploaded the store folder and overwrote the entire thing, then tried to install it again. Same error

Option C (use with caution)
Format H.D start all over again...

Edit..
thinking.. thinking....

Ok, just go to the DOS prompt and type 'format /u' right?

interesting i just tried it on my site and it worked

Yer not gonna believe this. I tracked it down... I gotta post a pic so gimme a minute... I found the null, LOL!

I was just about to post on this. But i will wait now to see your results.

I tracked it back to a user, user 9. I then opened his profile and found this...

now that makes no sense what has a user headline to do with module not installing hmm...

You could have at least wiped the email and name in that pic.

Anyhow. I fail to see why a null field in a profile would affect the adding of a admin menu item for the store, but it's dolphin, so who knows.

I do not know but it seems awful fishy to me..... It was certainly entered that way, I don;t see how the site scripts could have created it

 As for the email, it's a photo. I don;t think the spam bots can read photos yet (or can they?) In any case, this user is not active on my site and I would have to make the assumption he entered this info the way it sits

This line just before the errored line which obtains the next order number.

SET @iMaxMenuOrder := (SELECT `Order` + 1 FROM `sys_menu_top` WHERE `Parent` = 0 ORDER BY `Order` DESC LIMIT 1);


That failing would result in a null value which would explain the error. It makes more sense. But as i said, it's dolphin, so whatever.

Hey, I'm certainly open for suggestions...... I'm going to delete this profile but me thinks it isn't gonna change a thing

edited my profile to null ---null--- to see if i could recreate this error and no it installed

Try going into the admin menu builder. administration/menu_compose_admin.php

Move some top level items around to force a renumbering of the menu order fields in the database and see if that helps.

I did that already. No change.

Check this out. I took a loot at 'Austins' profile page. This is what his menu looks like

Profile Listings Info Friends SkyForum's List Blog Poll Sounds Videos Files Photos Sites Events Groups Wall _bx_store_menu_my_products_profile

God I hate this fish forum.

  Profile Listings Info Friends SkyForum's List Blog Poll Sounds Videos Files Photos Sites Events Groups Wall _bx_store_menu_my_products_profile

in sys.page compose look for store and delete all references to it  try installing again

Ok, but here's another interesting note

His member ID is 10

LOL, this is like mystery theatre!

No go. same issue. I even deleted the member

Can I just cut n paste the content of the uninstall.sql file into the query field to remove all references to the store? then reinstall?

you got mail

got mail, used mail, still got grief

Isn't the store dependant on other mods?

payment & files module but it won't show since it cant process the installation

Ok, then what if I ran the uninstall.sql query to completely remove all traces of the mod from the database. I cannot run the uninstall from the admin screen as it thinks it's already uninstalled. Maybe we're just caught is some sort of lala land here.

I'm gettin a headache. Maybe remove files and payment mods and start over?

Save out the sql statement you want to run as yoursql.sql.

It's important you have the .sql extension as you will be doing an import of the file.

Login to phpMyAdmin and import it.

That's what I've done before and it's worked for me.

This problem came about as a result of the update somehow. Have not successfully uninstalled it, only tried to reinstall it. Should I run the uninstall.sql file for store before trying to reinstall it again?

Yes, otherwise you will have a table(s) conflict(s) in your database.

You might to check to make sure that the Order field in your sys_menu_top is set to the default number "0".

 Order field is set to 0. Uninstalled and reinstalled and still got the same error.

Ok, nothing is working. I just tried to uninstall files, needed to uninstall groups first. I uninstalled groups then tried to reinstall it. Got the SAME erro I have been getting with stores.

This is unbelievable. what the helkl is going on>?

Ok, uninstalled my business directory successfully, then groups installed properly after that. Then tried to run store install and got this

 Error SQL query: -- create forum tables CREATE TABLE `[db_prefix]forum` ( `forum_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `forum_uri` varchar( 255 ) NOT NULL default '', `cat_id` int( 11 ) NOT NULL default '0', `forum_title` varchar( 255 ) default NULL , `forum_desc` varchar( 255 ) NOT NULL default '', `forum_posts` int( 11 ) NOT NULL default '0', `forum_topics` int( 11 ) NOT NULL default '0', `forum_last` int( 11 ) NOT NULL default '0', `forum_type` enum( 'public', 'private' ) NOT NULL default 'public', `entry_id` int( 10 ) unsigned NOT NULL , PRIMARY KEY ( `forum_id` ) , KEY `cat_id` ( `cat_id` ) , KEY `forum_uri` ( `forum_uri` ) , KEY `entry_id` ( `entry_id` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8; MySQL said: #1050 - Table '[db_prefix]forum' already exists

You have GOT to be kidding me!

Ta hell with it. I'm going to see IronMan 2.... BBT

Problem has been resolved. Thanks again Prolaznik. A job well done and I PROMISE, I will establish a proper backup protocol as you have suggested.

I'm not sure what the resoltion was but I'm sure he'll explain it here.