Unknown column 'adminUSPSUser' in 'field list'

Author	« Topic »
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/06/2021 : 03:47:28 When I open Store Admin and select Main Settings I get the error. Unknown column 'adminUSPSUser' in 'field list' Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /homepages/37/d415519235/htdocs/fb-design/vsadmin/inc/incfunctions.php:1818 Stack trace: #0 /homepages/37/d415519235/htdocs/fb-design/vsadmin/inc/incmain.php(167): ect_fetch_assoc(false) #1 /homepages/37/d415519235/htdocs/fb-design/vsadmin/adminmain.php(41): include('/homepages/37/d...') #2 {main} thrown in /homepages/37/d415519235/htdocs/fb-design/vsadmin/inc/incfunctions.php on line 1818 Can anyone advise me how to correct this error please? Many thanks John
Phil ECT Moderator United Kingdom 7681 Posts	Posted - 02/06/2021 : 04:27:47 Hi John, Can you check now and see if the error is still there please? * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/06/2021 : 06:17:18 Sorry for the delay Phil The error is still there
Phil ECT Moderator United Kingdom 7681 Posts	Posted - 02/08/2021 : 03:59:20 Hi John, It appears that the updatestore script hasn't added a couple of columns/field names Can you check that the database on the server has a table named adminshipping and check that it has the following columns: adminShipID adminPacking AusPostAPI adminCanPostUser adminCanPostLogin adminCanPostPass adminUSPSUser smartPostHub adminUPSUser adminUPSpw adminUPSAccess adminUPSAccount adminUPSNegotiated FedexAccountNo FedexMeter FedexUserKey FedexUserPwd DHLSiteID DHLSitePW DHLAccountNo shipStationUser shipStationPass * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/08/2021 : 04:06:58 Thanks Phil Where do I find the database please?
Phil ECT Moderator United Kingdom 7681 Posts	Posted - 02/08/2021 : 05:15:23 Your host control panel should have a database management tool named phpmyadmin Take a look in there. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/08/2021 : 06:10:25 Adminshipping is there OK and all the fields are correct. I notice one comment at the base of the table No partitioning defined!
Phil ECT Moderator United Kingdom 7681 Posts	Posted - 02/08/2021 : 06:40:49 In that case can you make sure you uploaded all the files when you applied the updater? I would just upload them all again to be sure * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/08/2021 : 07:15:27 Thanks Phil May I just recap just to make sure. I do not upload the phpplusupdate_v7.2.5_ folder I open the folder and upload the files contained in phpplusupdate_v7.2.5_ Is that correct? Thanks John
Phil ECT Moderator United Kingdom 7681 Posts	Posted - 02/08/2021 : 07:26:22 That's correct. Using FTP I just drag and drop the vsadmin, js and css directories over to the site root and overwrite the existing Then upload emailfriend.php and updatestore.php Remove updatestore.php after browsing to it * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback Edited by - Phil on 02/08/2021 07:27:41
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/08/2021 : 09:18:13 Thanks Phil thats working correctly now no more errors. When I look at VS Admin I wonder whether this contains the correct files. I have vsamin adminimages assets css custompayproc images inc js vsadmin adminimages assets inc
1818charlie ECT Moderator United Kingdom 1194 Posts	Posted - 02/08/2021 : 11:23:28 Hi John On the actual server, and depending on your own configuration, you should see folders named adminimages, assets, inc and possibly froala if you are using that editor. You shouldn't be seeing the .js & .css nor should you have duplicates of the above folders Steve Egerton Village, Bolton, UK Edited by - 1818charlie on 02/08/2021 11:27:51
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/08/2021 : 12:52:20 [img]https://net100.co.uk/vsadmin list.JPG[/img] Hi Steve. Within the directory vsadmin as shown I should delete: css custompayproc images js vsadmin ? I have not used Froala Many thanks John
1818charlie ECT Moderator United Kingdom 1194 Posts	Posted - 02/08/2021 : 13:23:57 Hi John Sorry I posted wrong info. Yes, keep the adminimages, assets & inc folders & delete the duplicate folders dated 02/02/2021 Steve Egerton Village, Bolton, UK Edited by - 1818charlie on 02/08/2021 13:27:14
dbdave ECT Moderator USA 10411 Posts	Posted - 02/08/2021 : 13:29:10 There are other files that do not belong as well. About.php about-sidebar.php and maybe more.. David
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/09/2021 : 03:14:36 Thanks for the previous help. In the image I have marked some files and folders for removal. In the top RHS I can see two vs admins should the lower vsadmin inside the top vsamin be removed? Looking at the LHS top vsadmin are the correct files in the lower panel correct please? [img]https://www.net100.co.uk/vsadmin list No2.JPG[/img]
Phil ECT Moderator United Kingdom 7681 Posts	Posted - 02/09/2021 : 03:30:37 yes it should, you have a vsadmin directory within the functional vsadmin directory and the custompayproc and images directories can also go. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback Edited by - Phil on 02/09/2021 03:32:37
JH10 Advanced Member United Kingdom 304 Posts Pre-sales questions only (More Details...)	Posted - 02/09/2021 : 06:29:52 Hi Phil I have marked all of those files for deletion and it still works! I will delete them all. Many thanks for all the help John
	« Topic »