Andy....
Went into the database through the command prompt. All the tables are there... i think. Total of 34 tables in all...... Is this correct?

Could I have a corrupt createdb.php file? Have removed the database files several times.... keep getting the same result.
Mark

Hi Mark,
There should be more than 34 tables.
Would you like to send me your server cpanel details and I'll sort this out for you. It shouldn't take longer than 10 minutes. Just click on my name and send me an email.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Phil,
Thanks for the reply. I didn't use a cpanel to create the database. Have had issues with getting phpmysql to load. Went into the MySQL file and created a database with the command prompt. It was empty. ran createdb... with limited results.
Peter told me I could create it through MySQL workbench or the command prompt. What information do you need?

I am running Apache 2.4 with PHP version 7.3 on a Dell Server with Server 2008 R2.... dedicated fiber optics line.
Thanks for you help.... this is stressing me out.... sorta!!
Mark

Who are you hosting with?
If you can send me the hosting panel login details to phil at bettapages dot com - don't post them on here :-)



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Phil,
First.... thanks for your response.
I didn't use a cpanel format. This is hosted on our server here. We are running Apache 2.4, PHP ver 7.3 and MySQL 8.0 on a Dell T310 with a dedicated fiber optics feed.

I created the database in the command prompt and it was empty prior to running the createDB.php. The MySQL directory is C:\\MySQL. it creates some of the databases as far as I can see.

I went back into the MySQL and ran Use SWD; show tables; and the result was 34 tables showing up.
Mark

Phil.....
Sent you an email
Mark

I've just sent you an sql file. Just import that file from the mysql console using the following commands

USE swd;

Then load the dump file like this (change the path to suit the location of the file on your system)

SOURCE C:\Users\Phil\Desktop\swd.sql



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Thanks Phil....
Have not got it yet.....
Mark

I sent it quite a while ago - I'll send it again. Just check your junk folder



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Phil...
I have the file you sent. Not gonna sugar coat it... we are on virgin territory here!

Should I remove the database I have already created?
As you know none of the SQL files don'tshow up in windows.... at least mine don't.

I have done everything from the command prompt. When I open the MySQL workbench..... the SWD file is there.... but, no tables. In the command prompt is see the 34 tables.
I am thinking that the workbench creates tables in one place... and I have created them in the command prompt in another. From the command prompt I have the MySQL folder in the root (C:\\)
Mark

Ops..... Spoke out of turn
Found the files in Windows explorer...... it is the one I created from the command prompt.
looks like I have .MYD .MYI and .sdi files for each table.

I am a bit unclear what to do with the file you sent.
Mark

There's no need to remove the database you have created, the sql dump file I've sent you will drop any tables that already exist and recreate them.

So all you need to do is the following:

1. Place the swd.sql file I sent you on the desktop of the PC the server is on
2. From the MySql console command prompt type the following below, pressing the enter key after each command. You will be prompted to enter a password in the outset then type

USE swd; (then press enter)

Then type the path to the sql file altering the path C:\Users\Phil\Desktop\ to the correct path on your PC

SOURCE C:\Users\Phil\Desktop\swd.sql (then press enter)


That's all you have to do, the sql file will then import to the swd database




* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

SHAAA-ZAAAAMMM!!!!

SUCCESS!! Thanks Phil!!!!

I assume I am going to have to do the same thing on the other websites with the older createdb.php files.
Mark

Almost hate ask..... where is the password set for the vsadmin page login?
Mark

The login would be the standard mystore / chnageme I assume.

For the other sites I would use the same vsadmin folder and createdb.php file as this one as the others are older and won't support PHP7

Andy

Please feel free to review / rate our software

mystore /changeme ??

Where can I find this
Mark

You would enter that at yourstoreurl.com/vsadmin/login.php

Andy

Please feel free to review / rate our software

Okay... done that..... I am guessing there is a default user name and password.
Mark

Okay..... I did the proper modifications to the store running version (or build) 6.4.4.003.
Ran the script that Phil sent and have the 50 tables as required.... and what is running fine on the site with build 6.7.4.000

The following error show up on the 6.4.4.003 build when ran:

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; vrNodeList has a deprecated constructor in C:\Apache24\htdocs\InMarshal.org\Store\IMA Store\vsadmin\inc\incfunctions.php on line 231

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; vrXMLDoc has a deprecated constructor in C:\Apache24\htdocs\InMarshal.org\Store\IMA Store\vsadmin\inc\incfunctions.php on line 306

Fatal error: Uncaught Error: Call to undefined function set_magic_quotes_runtime() in C:\Apache24\htdocs\InMarshal.org\Store\IMA Store\vsadmin\inc\incfunctions.php:10 Stack trace: #0 C:\Apache24\htdocs\InMarshal.org\Store\IMA Store\vsadmin\login.php(16): include() #1 {main} thrown in C:\Apache24\htdocs\InMarshal.org\Store\IMA Store\vsadmin\inc\incfunctions.php on line 10

Those admin files are pre ECT 6.7 though aren't they? That's why I suggested using the 6.7 files for the other sites. You could run the updater on them and check the syntax as per my earlier post.

Andy

Please feel free to review / rate our software