Wilky Posted May 19, 2009 Share Posted May 19, 2009 Hi, This is my first post and this is all new to me, iv'e had a site for some time now and not been involved with the building of it. I have just recently moved hosting company's and this is the error 1054 - Unknown column 'p.products_id' in 'on clause i have been left with my new host did the free transfer of site from my old host and told me i will have to sort the problem out myself! Ok i think i should able to do this have read the already posted topics on this error on this forum, but here's where i now show how green iam.. on cpanel with my new host i click on file manager and then i can find the index.php file i can veiw it but when i click on html editor nothing happens it's not highlighted when index.php is selected, is this something to do with permissions if so how do i change them to then edit?? Thankyou John Link to comment Share on other sites More sharing options...
morehawes Posted May 19, 2009 Share Posted May 19, 2009 Hi John, in order for you to fix the problem you're going to need FTP access to your hosting. They should of provided FTP login details when you signed up and you can then enter these into a FTP program like FileZilla to access the files. Once you have access then we can try to find the cause of the problem. All the best. Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
Wilky Posted May 19, 2009 Author Share Posted May 19, 2009 Hi Joe, All i have from hostgator is my log in details to my cpanel which my site has been transfered too, i havent yet directed my name servers to them as yet as it's taken nearly a week for them to tell me they carn't help me now! that is te only log in info i have? John Link to comment Share on other sites More sharing options...
morehawes Posted May 19, 2009 Share Posted May 19, 2009 Hi, you should be able to manage FTP accounts in cPanel for the domain. Once you have a FTP account set up then you can use FileZilla to access your files. Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
Wilky Posted May 19, 2009 Author Share Posted May 19, 2009 Joe, I have now setup a ftp account whats next ? i need to get filezila then? Link to comment Share on other sites More sharing options...
morehawes Posted May 19, 2009 Share Posted May 19, 2009 Install FileZilla and enter your domain, FTP username and password and connect to your hosting. Then you shuold be able to locate your index.php file and download it. Once downloaded you will be able to open it in a text editor to look at the code. Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
Wilky Posted May 19, 2009 Author Share Posted May 19, 2009 Joe, Thanks for helping iam having probs at the moment trying to get filezila to connect with my cpanel iam having 530 login authentification failed i believe every thing i have entered is correct? Username correct iam putting in the correct password checked it still wont work.. Link to comment Share on other sites More sharing options...
morehawes Posted May 19, 2009 Share Posted May 19, 2009 Have you entered the host as the domain name (or ip address) the same as when you browse your site? What I mean is if your site is www.mysite.com then have you entered 'www.mysite.com' as the host? Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
Wilky Posted May 19, 2009 Author Share Posted May 19, 2009 Ok, What i have now done is i was trying to connect to my new host and without success, i have now tried with my old host and now i have connected, my site is still live with the old host because of the trouble ive had with the new i havent yet pointed the name servers to the new host as yet, Would i be able to take a copy of index.php from my site on the old server modifie it then send it back to my new one when i can figure out why i cannot connect? Link to comment Share on other sites More sharing options...
morehawes Posted May 19, 2009 Share Posted May 19, 2009 Sounds OK as long as you've not modified the new copy, which by the sounds of things you've not be able to do. Plus before overwriting the new copy you'll want to make a backup (again once you can connect!) just in case. Joe MacMan strikes again! Always backup first before listening to me! Link to comment Share on other sites More sharing options...
MrPhil Posted May 19, 2009 Share Posted May 19, 2009 I have just recently moved hosting company's and this is the error 1054 - Unknown column 'p.products_id' in 'on clause i have been left with my new host did the free transfer of site from my old host and told me i will have to sort the problem out myself! Your new host is probably running MySQL 5, which is not quite compatible with osC (written for MySQL 4). Take a look here: Tips and Tricks osC and MySQL 5 - 1054 errors 04/30/09 http://www.oscommerce.com/forums/index.php?sho...=335136&hl= for what usually causes these 1054 errors, and how to fix it. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.