Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?


Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site

 All Forums
 Technical
 Getting Started and Pre-Sales
 Installing Template
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic   

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/11/2020 :  09:02:25  
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

Phil
ECT Moderator

United Kingdom
7184 Posts

Posted - 09/11/2020 :  09:28:59  
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*

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/11/2020 :  12:21:26  
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

dbdave
ECT Moderator

USA
8797 Posts

Posted - 09/11/2020 :  14:00:19  
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

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/12/2020 :  01:30:50  
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

Vince
Administrator

39437 Posts

Posted - 09/12/2020 :  01:35:07  
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

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/12/2020 :  02:09:24  
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?


1818charlie
Ecommerce Template Expert

United Kingdom
616 Posts

Posted - 09/12/2020 :  04:32:30  
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

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/12/2020 :  05:51:59  
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

dbdave
ECT Moderator

USA
8797 Posts

Posted - 09/12/2020 :  08:08:16  
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

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/13/2020 :  03:14:11  
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

Phil
ECT Moderator

United Kingdom
7184 Posts

Posted - 09/13/2020 :  03:16:21  
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*

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/13/2020 :  09:35:37  
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

dbdave
ECT Moderator

USA
8797 Posts

Posted - 09/13/2020 :  09:38:27  
Hi John, when you attempt to access the admin ( ~website~/vadmin/login.php ) do you get any kind of error message?

Thanks,
David

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/13/2020 :  10:28:37  
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

Phil
ECT Moderator

United Kingdom
7184 Posts

Posted - 09/13/2020 :  10:31:22  
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*

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/13/2020 :  11:44:52  
Sent Phil

John

Phil
ECT Moderator

United Kingdom
7184 Posts

Posted - 09/14/2020 :  01:24:20  
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*

JH10
Advanced Member

United Kingdom
129 Posts

Posted - 09/14/2020 :  11:50:42  
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
   Topic   
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2020 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000