close ad
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


Database upload error

Thread began 6/04/2010 11:56 am by benkurbis21381769 | Last modified 7/01/2010 5:17 pm by Eric Mittman | 1392 views | 3 replies |


Database upload error

I set up store on my local server, then uploaded it to server. Changed the powerstoreconnection.php and went through database file to change database name and user to match what i have set up with my host. When trying to import my database from local server i get the following error.
SQL query: Documentation

-- --------------------------------------------------------
-- Table structure for table `ps3_coupondelete`
CREATE ALGORITHM = UNDEFINED DEFINER = `myusername`@`localhost` SQL SECURITY DEFINER VIEW `p15s6pfm_shop`.`ps3_coupondelete` AS (
SELECT `p15s6pfm_shop`.`ps3_couponproducts`.`CouponProductID` AS `CouponProductID` , `p15s6pfm_shop`.`ps3_couponproducts`.`CouponID` AS `CouponID` , `p15s6pfm_shop`.`ps3_couponproducts`.`ProductID` AS `ProductID` , concat( `p15s6pfm_shop`.`ps3_couponproducts`.`CouponID` , _latin1 '_', `p15s6pfm_shop`.`ps3_couponproducts`.`ProductID` ) AS `JoinedKey`
FROM `p15s6pfm_shop`.`ps3_couponproducts`

MySQL said: Documentation
#1227 - Access denied; you need the SUPER privilege for this operation

Sign in to reply to this post

Eric Mittman

It looks as though you may not have permissions to create views on your live server. If you are able to you should try adjusting the permissions that you have to allow for create view.

In the download area for PowerStore there is a known issues fix for users that do not have the ability to create views. You can download the files and read the read me for instructions on where to put the files.

These files are designed to be put in place before the store is installed. It is not recommended to manually install the store on your server. If you had gone through the installer on your server you would have been warned that you did not have the permissions to create the view.

Sign in to reply to this post


write poem

I ran into the same exact problem when trying to connect my database that I was using for my local server to the remote server. I have already done the installation wizard through the local host. I updated the 5 or so files:

# install/2.php
# install/scripts/db.sql
# Admin/Update_ProductCoupons.php
# Admin/Products_Results.php
# WA_DataAssist /WA_AppBuilder_PHP.php

I made these updates and then tried to re-upload them to the remote server through FTP software. I am still getting the same error: #1227 - Access denied; you need the SUPER privilege for this operation.

Will I have to completely remove my files from my hosting provider and start over??? This seems a little troublesome, as I have been spending a week or so now adding products and such to my store. Please help me out.


Sign in to reply to this post

Eric Mittman

The installation must run with the updated files in order to get past the limitation of not being able to create views. If you ran it locally first then the db was created with the view. You will need to run the installation on your live server. Once you do that you can then export all of the tables that you have in your db to the live server, just make sure that you don't try to export the view or you will have problems.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...