Hello
First Steps in an installation!

I created a blank database and then ran the file createdb
Looked a good result
Everything installed successfully !

In the generic version I ran the index.php and this produced an error

My sample products
Unknown column 'emailfromname' in 'field list'
Fatal error: Call to a member function fetch_assoc() on boolean in C:\xampp\htdocs\FB-ECT\vsadmin\inc\incfunctions.php on line 1737

Nothing else appeared on the page.
The data is in the database looks OK

I also noticed a syntax error in Dreamweaver in incfuntions.php on line 56

55 if(@$GLOBALS['dateformatstr']=='') $GLOBALS['dateformatstr']='m/d/Y';
56 $GLOBALS['zipoptional']=[85,91,149,154,200];
57 function getadminsettings(){

Any ideas where I am going wrong please?
Thanks
John

Hi John,
I see this is on your localhost but shouldn't be a problem really.
Can you download the latest updater from here - https://www.ecommercetemplates.com/updaters.asp
Apply it fully and run the udatestore.php file in your browser.

Let us know how you get on please and post back if you have further problems.



* 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
I can now see updatestore.php as a Notepad++ file along with a few other files but I am not sure what to do with this. I suspect I copy this to my files somewhere.
Can you please advise me?
Many thanks
John

Hi John, the updatestore file should be uploaded to the store root (where the files are) and run that in your browser. It will update the database tables.
From the error you posted, it's possible you have a set of files that is from a different version than what the database is on.
I suspect this is why Phil suggested an update to get those synced up.

Thanks,
David

PS - Additional updater help here - https://www.ecommercetemplates.com/updater_info.asp

Thanks David,
I uploaded the updatestore.php file but it made no difference.
I am still getting the same error message on the index.php page

My sample products
Unknown column 'emailfromname' in 'field list'
Fatal error: Call to a member function fetch_assoc() on boolean in C:\xampp\htdocs\FB-ECT\vsadmin\inc\incfunctions.php on line 1737

btw is there any way on this forum to attach an image or a file?
Regards
John

Hi John
Setting your own server up on localhost can be tricky, and it's not normally really necessary. Why not just set up the site on your web server? If you don't want to overwrite the current website, then just set it up in a subdirectory. Then if you have any problems we can log in and sort it out.
Yes though, you can post an image. Just look at the buttons above where you are typing your post and click on the "Insert Image" one. Then enter the URL of your image between those tags. The image will need to be stored on your server and enter the full URL for example...
http://www.yourstoreurl.com/yourimage.gif

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Thanks Vince,
I have uploaded the files and database but get passed to the ionos error page when the site is run.
the url is http://net100test.co.uk/fb/fbetc

Should db_conn_open_remote.php be changed to db_conn_open.php after uploading?

The error message
Unknown column 'emailfromname' in 'field list'
I had a look in the database but could not see this.
Which table should contain this field?

quote:

---

Should db_conn_open_remote.php be changed to db_conn_open.php after uploading?

---

Yes it should. The website won't connect to the database using db_conn_open_remote.php

Steve
Egerton Village, Bolton, UK

Thanks Steve,
I amended the remote file name however no change, still opening the ionos error page

This part of the message looks important,

Unknown column 'emailfromname' in 'field list'
I had a look in the database but could not see this.

I can see one table called emailmessages but there is no field called 'emailfromname'

Which table should contain this field?
Regards
John

Hi John, the unknown column will likely mean that the files are asking for that database column, but it's missing.
Running an update (and running the updatestore.php script in your browser) should add any database tables/columns that are missing.

I know you mentioned that you uploaded that file, but did you run it in your browser to add the columns that are missing?

Thanks,
David

Thanks dbdave,

I can now access the website on my localhost so that's good news, but the site will not open on my remote server so I cannot run the update.

Should the connection file be in root or vsadmin. I received a message it should be in vsadmin.

John

quote:

---

Should the connection file be in root or vsadmin. I received a message it should be in vsadmin.

---

In the vsadmin directory



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

Yes it is in the vsadmin directory.

I still cannot get the site working in remote just cannot think why.

Any suggestions welcome!
Cheers

John

Hi John, when you attempt to access the admin ( ~website~/vadmin/login.php ) do you get any kind of error message?

Thanks,
David

Hi David
No matter which page I use on FB-Design.co.uk I am getting an error on remote.
Something seems to have gone amiss maybe on the remote server.

Some other test pages I had in a directory on the remote server for testing were working fine.

I now see these are failing as well.

Thanks

John

Hi John,
Would you like to send me your FTP details to phil at bettapages dot com and I'll take a quick look for you?



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

Sent Phil

John

Hi John,
Just replied to your email, I'm having problems gaining FTP access with the credentials you sent me.



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

Thank Phil and everyone,
I eventually had this I think rectified by ionos support no idea what they did! The support person asked me to open the site and as I did my internet died!

A few items outstanding so I will raise another ticket.
Thanks again.
John