Duplicate Fields appear in "My Store" = Config_Group 1

Greetings Web Peeps--

My fresh installation of osCom is yielding some mysterious duplicate fields while viewing the "My Store" option of the config in the browser window [see screen scrape below from:
.../osCommerce/admin/configuration.php?gID=1]
-------------------------------------------------------
My Store

Title Value Action
Store Name
E-Mail Address
E-Mail From
Store Owner
Country United States
Zone Florida
Zone Florida
Expected Sort Order asc
Expected Sort Field products_name
Switch To Default Language Currency false
Switch To Default Currency false
Send Extra Order Emails To
Send Extra Order E-Mails To
Use Search-Engine Safe URLs (still in development) false
Use Search-Engine Safe URLs false
Display Cart After Adding Product true
Display Cart After Adding Product true
Allow Guest To Tell A Friend true
Allow Guest To Tell A Friend false
Default Search Operator and
Default Search Operator and
Store Address and Phone Store Name Address Country Phone
Store Address and Phone
Show Category Counts true
Show Category Counts true
Tax Decimal Places 2
Tax Decimal Places 2
Display Prices with Tax false
Display Prices with Tax false
-------------------------------------------------------
See?

Now, I did have some installation woes (had to delete and re-install a couple of times) but all seems well as far as making the catalog/install directory go away and arranging for security via the .htaccess and protect.php tricks are concerned.

?

In an effort to have a peek at the database, I even downloaded MySQLControl Center and had a look at the SQL tables and fields. It seems that there are no duplicate fields in the table named:
configuration

[Screen capture of table attached]

So either I'm not looking in the right place in MYSQLCC or the duplicates are just appearing in the browser and are not actually in the database (but this doesn't seem to make sense to me).

Any suggestions on:

1. WHY THE DUPLICATES APPEAR IN THE ADMIN "MY STORE" SCREEN VIA THE BROWSER?

2. HOW TO DELETE THE DUPLICATES?

3. WHERE ELSE TO LOOK IN THE DATABASE FOR POTENTIAL PROBLEMS?

4. WHAT ELSE I MAY BE OVERLOOKING BEFORE I TRY TO POPULATE MY STORE WITH PRODUCT.

5. A QUICK WAY TO REMOVE THE DUMMY PRODUCT DATA FROM THE STORE THAT WAS CREATED UPON INSTALLATION.

Thanks ever so much.

--WebDiva

[stevel]

I saw this happen when I did a reinstall without wiping out the database first. You'll need to delete ("drop") all the tables and try again.

If there is a quick way to remove the sample stuff, I don't know about it. There probably is an SQL script somewhere that will do it. I just spent about 20 minutes doing it manually. Don't forget to also delete the images that go with the dummy products and manufacturers.

Hey Doc--

Thanks for the fast attention!
Drop all the tables...OK.
Is this something I can do with MySQLCC on the database end alone?

-OR-

Do I have to dump EVERYTHING on the http: side of the house as well?

Please forgive my ignorance, as I am not a database hustler.





--WebDiva

[stevel]

I use MySQL-Front, select all the tables and click the X button "Drop Table...". Leave the HTML alone. You'll then need to reload the initial data, provided as oscommerce.sql in the catalog/install folder. You can use MySQL-Front for that too (Import Textfile).

I don't know MySQLCC, but any MySQL management tool can do the same thing - only the details will vary.

Hmm - just looked again at the oscommerce.sql file - it should wipe out what was there before on its own. Doing so manually doesn't hurt.

Steve--

Thanks for the second thoughts. I had followed some instructions to delete the catalog/install dir but did manage to save a local copy of the oscommerce.sql file, which I will use. I really like the idea of importing that file and overwriting all the nasty stuff with it, but I don't see an import feature that is enabled. Any ideas? Anyone?

I really want to avoid deleting the http: osCommerce directory again, so I'd really like to repair the SQL stuff without having to mess with the .php + .html

So, I have a quick question: I am searching for the "drop" function in MySQLCC and I came across the 'x', however when I elect to try the "drop" it seems that I can only "drop" the entire database (in my case called soul_studies). Do you think it's a BAD THING to "drop" database from my side on POWWEB? I'm not certain if that's the answer to my prayers or not. It seems a little serious... [see attached screen captures]

When I right click on "Tables" there doesn't seem to be a drop option enabled.

You're sensational for writing! THANKS!

--WebDiva

[stevel]

WebDiva,

Sorry, but I don't know the tool you're using. I have used both MySQL-Front and phpMyAdmin, and they both allow import and export. MySQLCC may call it something different.

Hey Steve--

OK. I converted over to using MySQL Front. I dropped all the tables and the database. I created a new database named identically to the original and get the following error when attempting to import the 'osCommerce.sql' file from the catalog/install directory.


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 '()' at line 1

What gives?

Should I go the phpMyAdmin route?

Thanks for sticking with me



--WebDiva

[stevel]

My guess is that it's because the oscommerce.sql from the distribution is in UNIX/Linux format, with only line-feeds between the records, instead of the CR-LF that Windows wants. Try this.

Open oscommerce.sql in WordPad - NOT Notepad.
File..Save As. Select Save as type: Text Document MS-DOS Format. Change the name to osc2.sql and save.

Now see if MySQL-Front is happier.

Steve!

While I was waiting for a reply I dumped the whole osComerce directory, dropped the database and decided to reinstall osComerce from scratch.

The soul_studies database was completely empty when I started and THIS IS THE STEP THAT CREATED THE DUPLIATE FIELDS!

http://soulstudies.com/osCommerce/ca...ade.php?step=3

See erors below:

Upgrade

Step 1: Database Upgrade

* Address Book
* Banners
* Categories
* Configuration
* Currencies
* Customers
* Images
* Languages
* Manufacturers
* Orders
* Products
* Reviews
* Sessions
* Specials
* Taxes
* Whos Online

Status: Update Complete!


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/s/soulstudies/htdocs/osCommerce/catalog/install/includes/functions/database.php on line 45

The database upgrade procedure was successful!

What the heck did I do wrong?

<sigh/>

--WebDiva

[stevel]

Dunno - I've never used the upgrade option, which is intended to be used if you have existing data in your database.

Steve--

THANKS!
I did the following:

Open oscommerce.sql in WordPad - NOT Notepad.
File..Save As. Select Save as type: Text Document MS-DOS Format. Change the name to osc2.sql and save.

YET...
SQL Front is not happy.

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 '()' at line 1

Should I just refrain from taking the Step 3 of the installation
(database upgrade?)

Please advise, see previous posting...

Thanks!

--WebDiva

[stevel]

At this point, I suggest redoing the install as a new install, rather than an upgrade. I'm not sure where else to go from here.

Which version of osc are you installing?

Steve--

Frustrating, yes. Thanks for all the attempts :-)

I am running the POWWEB unpack and install from the OPS screen. I am unsure as to the version specs.

--WebDiva

[stevel]

You may want to consider downloading 2.2-MS2 instead, as I describe in another thread here. It's a lot newer than the one PowWeb installs.

Steve--

Can you reference the thread so might refer to it?
Also, can you recommend a source [link] to 2.2-MS2 installation instructions?

Thanks!

--WebDiva