seanpaul Posted March 6, 2003 Share Posted March 6, 2003 AArrghh, Does anyone know how to reverse this query: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (263, 'Display Product Sort Order', 'PRODUCT_SORT_ORDER', '0', 'Do you want to display the Product Sort Order column?', 8, 9, '2003-01-23 20:48:06', '2003-01-22 23:23:50', NULL, NULL); My search facility on Osc 2.2 was working fine until I ran this query now it kicks up errors.. Any advice would be great, thanks all Link to comment Share on other sites More sharing options...
Guest Posted March 6, 2003 Share Posted March 6, 2003 Easiest way is if you have PHPmyadmin.... use this to browse your configuration table...... find the configuration_id (in your case 263)... then click "delete"... this will delete the whole row you entered with your original query Link to comment Share on other sites More sharing options...
seanpaul Posted March 6, 2003 Author Share Posted March 6, 2003 Thanks Dick, will give it a go :) Link to comment Share on other sites More sharing options...
seanpaul Posted March 6, 2003 Author Share Posted March 6, 2003 ok, i fixed that, unfortunatly the search error still exists 1064 - You have an error in your SQL syntax near ' m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.produ' at line 1 I know what the error in the syntax is, but, doh, I dont know how to get at it to make the necesary amendments. Link to comment Share on other sites More sharing options...
Guest Posted March 6, 2003 Share Posted March 6, 2003 Just open the file where the problem is in any good text editor (I use Ultraedit)... and make the necessary changes..... are you trying to install a contribution..? Link to comment Share on other sites More sharing options...
seanpaul Posted March 6, 2003 Author Share Posted March 6, 2003 Yeah I was doing, but my priorities changed so I put the contribution on the backburner, I was installing a 'products sort order' contrib. I was thinking my error was in the database but its not, I just have to make the necesary modifications to some of my .php files to bring them into line with the changes I've already made in the database. Link to comment Share on other sites More sharing options...
Guest Posted March 6, 2003 Share Posted March 6, 2003 he he... thought as much :roll: 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.