Database Trouble after moving ProductCart

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   This appears to be resolved.  Database users with insufficient permissions owned a variety of tables within the db. Additionally, many tables were duplicated.  I re-assigned ownership of the unique tables and deleted the empty duplicate tables. And for newbies who think this sounds hard and complicated, I'll share with you that I still recall those days when I would have had no imagination for what this all means.  It keeps one humble to remember what a long learning curve some of this can be.  Happy Sunday.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Topic: Database Trouble after moving ProductCart Posted: 27-April-2013 at 11:48pm
	This appears to be resolved. Database users with insufficient permissions owned a variety of tables within the db. Additionally, many tables were duplicated. I re-assigned ownership of the unique tables and deleted the empty duplicate tables. And for newbies who think this sounds hard and complicated, I'll share with you that I still recall those days when I would have had no imagination for what this all means. It keeps one humble to remember what a long learning curve some of this can be. Happy Sunday.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 9:06pm
	I have decided to get Greg to take care of this as he is can attend to this promptly for me, and there is some urgency to this.
	www.austcoldindustries.com.au

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 8:51pm
	Thanks Greg, Thought I should look into Mat's explanation of the error. I found that he is correct in that the DB Table is not there. I also checked this in the old server and found it was also missing there. Somehow the store has been functioning on the old server without it, and even though I am using the same files it now requests the DB Table. I know this sounds unlikely but it has been. Can anyone confirm what other DB Tables where added to the Database and in what upgrade release it was added.
	www.austcoldindustries.com.au

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 7:37pm
	Grant, I replied to you by e-mail. Perhaps Matt is going to be able to help. If not, get me the details I discussed in my e-mail.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:56pm
	However when it restored I got an error advising, "The database was restored successfully but some users require your attention."
	www.austcoldindustries.com.au

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:54pm
	Should all be the same, I used FileZilla to FTP all files to my pc and then FTP them to the new server. Used the backup feature in the control panel to backup and download database. Then created new database with same name and restored using the backup. Grant
	www.austcoldindustries.com.au

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:46pm
	The error you are showing means it needs a table that is not in your database. If the database is the same, then you must be using newer files without running a database update. If you tell me the files are the same, then I would say that this error must have been there before you moved.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:40pm
	Hi Matt, No it is the correct database, I have backed up from old server , created new one in new server and restored it using the file twice. Same result. It is showing the correct orders to date in the control panel. Grant.
	www.austcoldindustries.com.au

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:35pm
	Invalid object name 'pcCatPromotions'. means that your connection string points to a database missing that entire table. Seems like the database you restored was an old database.

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Posted: 27-April-2013 at 6:15pm
	Hi Greg, Would you just require FTP access at this stage or access to the Plesk Parallels control panel as well? I would like you to attend to this for me. I am confused as why this issue persists as I followed instructions for moving product cart. You can email direct via grant@austcoldindustries.com.au
	www.austcoldindustries.com.au