Ausgirl Posted March 15, 2007 Posted March 15, 2007 Hello, Ive installed RMA Returns but whenever I try to install the SQL I get either a blank page, page cannot be displayed, or Error SQL query: ALTER TABLE orders_products ADD products_returned tinyint( 2 ) unsigned default '0'; MySQL said: #1060 - Duplicate column name 'products_returned' or Error SQL query: ALTER TABLE orders_products ADD products_returned tinyint( 2 ) unsigned default '0'; MySQL said: #1060 - Duplicate column name 'products_returned' I ran the SQL once before and got this error, I checked the tables & they were there, after I completed the installation (upload files ect...) I got the tep stop missing table error in my Admin so I deleted the SQL tables & thought I would just reinstall the SQL, which I did but now I get all the above errors and no tables are installed. It just wont accept the SQL data yet the errors state that it is a duplicate? :blink: In case your wondering why I didnt post in the support thread for this, its because it seems to be a bit of a ghost thread. No one goes there. If someone could kindly tell me how to get this SQL data installed it would be much appreciated. Thanks Quote
Ausgirl Posted March 15, 2007 Author Posted March 15, 2007 and when I try to import the SQL I get this error: Error SQL query: # phpMyAdmin MySQL-Dump # version 2.3.2 # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Generation Time: Apr 07, 2003 at 03:11 PM # Server version: 4.00.12 # PHP Version: 4.2.3 # Database : `rma_osc` # -------------------------------------------------------- # # Table structure for table `configuration` # INSERT INTO configuration VALUES ( '', 'Default charge for restocking a non-faulty item', 'DEFAULT_RESTOCK_VALUE', '12.5', 'This is the charge applied to refund to cover the return of non-faulty items which are to be entered back into stock for resale', 9, NULL , '2003-03-01 15:22:17', '0001-01-01 00:00:00', NULL , NULL ); MySQL said: #1146 - Table 'wwwshop_osc1gzkeygzkeygzkey.configuration' doesn't exist Quote
Ausgirl Posted March 15, 2007 Author Posted March 15, 2007 I added each one seperately all were accepted except for 2 in which I cant get it too accept the "Return Status" or the "Returned Products" In Admin I get these errors when I clicked on "Returned Products" (1146 - Table 'wwwshop_osc1.returns_status' doesn't exist select returns_status_id, returns_status_name from returns_status where language_id = '1' [TEP STOP] and "Returns Status" Returns Status Action 1146 - Table 'wwwshop_osc1.returns_status' doesn't exist select count(*) as total from returns_status where language_id = '1' [TEP STOP] Anyone have any ideas as to why its not working, given that Ive installed the SQL. There are 8 tables installed all up. Quote
Ausgirl Posted March 16, 2007 Author Posted March 16, 2007 Hello, Anybody? Some one. Its more of an SQL problem then a mod problem I think. Isnt there someone whom could tell me how to get the database to accept these 2 little bits of code? Thanks Quote
screamager123 Posted August 28, 2007 Posted August 28, 2007 BUMP anyone discover a solution to this??? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.