ProductCart Shopping Cart Software Forums : Database Trouble after moving ProductCart https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 10 Apr 2026 19:18:28 +0000 Sat, 27 Apr 2013 23:48:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=5587 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Database Trouble after moving ProductCart : This appears to be resolved....]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21249.html#21249 Author: Greg Dinger
Subject: 5587
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.]]> Sat, 27 Apr 2013 23:48:06 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21249.html#21249 <![CDATA[Database Trouble after moving ProductCart : I have decided to get Greg to...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21248.html#21248 Author: austcold
Subject: 5587
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.


]]> Sat, 27 Apr 2013 21:06:26 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21248.html#21248 <![CDATA[Database Trouble after moving ProductCart : Thanks Greg,Thought I should look...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21247.html#21247 Author: austcold
Subject: 5587
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.
]]> Sat, 27 Apr 2013 20:51:11 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21247.html#21247 <![CDATA[Database Trouble after moving ProductCart : Grant, I replied to you by e-mail....]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21246.html#21246 Author: Greg Dinger
Subject: 5587
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.]]> Sat, 27 Apr 2013 19:37:02 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21246.html#21246 <![CDATA[Database Trouble after moving ProductCart : However when it restored I got...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21245.html#21245 Author: austcold
Subject: 5587
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."]]> Sat, 27 Apr 2013 18:56:57 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21245.html#21245 <![CDATA[Database Trouble after moving ProductCart : Should all be the same,I used...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21244.html#21244 Author: austcold
Subject: 5587
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]]> Sat, 27 Apr 2013 18:54:09 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21244.html#21244 <![CDATA[Database Trouble after moving ProductCart : The error you are showing means...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21243.html#21243 Author: Matt
Subject: 5587
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.  ]]> Sat, 27 Apr 2013 18:46:51 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21243.html#21243 <![CDATA[Database Trouble after moving ProductCart : Hi Matt,No it is the correct database,...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21242.html#21242 Author: austcold
Subject: 5587
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.]]> Sat, 27 Apr 2013 18:40:59 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21242.html#21242 <![CDATA[Database Trouble after moving ProductCart : Invalid object name &#039;pcCatPromotions&#039;....]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21241.html#21241 Author: Matt
Subject: 5587
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.]]> Sat, 27 Apr 2013 18:35:00 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21241.html#21241 <![CDATA[Database Trouble after moving ProductCart : Hi Greg,Would you just require...]]> https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21240.html#21240 Author: austcold
Subject: 5587
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]]> Sat, 27 Apr 2013 18:15:18 +0000 https://forum.productcart.com/database-trouble-after-moving-productcart_topic5587_post21240.html#21240