Hello,
I'm moving my ecommerce site from ASP to PHP. The transition so far has been smooth. The database was created nicely and logging into the main dashboard went well. Where I'm getting ill from is that I used the BullZIP program to convert my Access DB to a SQL zip file. It transferred in inserted smoothly, but when I try to log in I get the following:

Unknown column 'usemailer' in 'field list'
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /home2/braine/bjetest.com/M4S/vsadmin/inc/incfunctions.php:1803 Stack trace: #0 /home2/braine/bjetest.com/M4S/vsadmin/inc/incfunctions.php(61): ect_fetch_assoc(false) #1 /home2/braine/bjetest.com/M4S/vsadmin/inc/incloginfunctions.php(21): getadminsettings() #2 /home2/braine/bjetest.com/M4S/vsadmin/login.php(18): include('/home2/braine/b...') #3 {main} thrown in /home2/braine/bjetest.com/M4S/vsadmin/inc/incfunctions.php on line 1803

Does this make sense to anyone. Is there an easier way to transfer the database (it's quite large). I would HATE to redo the entire DB manually.

Brian Elefant

There is a little bit more to it than just "converting" it, but in this case you have a mismatch between your database version and the script version.

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Hi Brian, you might try to download and run the .php updater to see if that sets things right.
Just don't toss your access database in case you need to start over.
If you continue to have problems, and this type of thing can be tricky, I highly suggest you reach out to Phil at bettapages ( https://www.ecommercetemplates.com/developers.asp ).
He is really great with databases, and has done these types of conversions for other folks here.

Thanks,
David

quote:

---

I used the BullZIP program to convert my Access DB to a SQL zip file. It transferred in inserted smoothly, but when I try to log in I get the following:

---

I would check a few of the field attributes are correct before you continue. That program will not make the necessary changes required for the php version.

We only charge an hour or so to upsize your access database to mysql so if you're still having problems let me know.



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