Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

remoteone

Archived
  • Posts

    6
  • Joined

  • Last visited

Profile Information

  • Real Name
    Joe Anderson

remoteone's Achievements

  1. Yep, I was doing it wrong. Despite my immense grattitute to the contributors of all the contributions, perhaps the installation instructions (this applies to all contribs, not just this one)need to be more explicit, for those of us that have never used phpMyAdmin until now. The key here is 'knowing what your doing". It would be easier to know what I'm doing if the instructions told me what to do ! So when importing the SQL scripts, for this contrib, ensure that Format of imported file>> set to SQL >>Options>> SQL compatibility mode>> is set to MYSQL4. Other wse phpMyAdmin will not recognise '' as a valid integer value. Thanks for coming. :blink:
  2. Ok well I myst be oing something very wrong. Am i doing it wrong, or is something no go on my pute?
  3. And when trying to run [group_file_for_download.sql] i get this BS: Error SQL query: Documentation 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 ( '', 'Enable Group File Download?', 'DOWNLOADS_CONTROLLER_FILEGROUP_STATUS', 'Yes', 'Do you want to enable group file for download? - Default=Yes', '13', '93', NOW( ) , NOW( ) , NULL , 'tep_cfg_select_option(array(\'Yes\', \'No\'), ' ); MySQL said: Documentation #1366 - Incorrect integer value: '' for column 'configuration_id' at row 1
  4. Ok I feel a bit silly, you select the db on the lhs colum of phpMyadmin, but now I get this error.: Error SQL query: #NEW FIELDS FOR DOWNLOADS CONTROLLER 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 ( '', 'Downloads Controller Update Status Value', 'DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE', '12', 'What orders_status resets the Download days and Max Downloads - Default is 12', '13', '90', '2003-02-18 13:22:32', '', NULL , NULL ); MySQL said: Documentation #1366 - Incorrect integer value: '' for column 'configuration_id' at row 1 yep.. theres no table for 'configuration_id' but why not?.
  5. Hello Will, Yeah I had A similar issue with understanding the instructions., as I also didnt know what "run the SLQ scripts"meant. I'm running my project at this point on mt PC as localhost, and havent got to the upload to website stage yet. I installed phpMyAdmin and spent an eternity sorting out the errors generated by the dodgy php.ini file. My assumption is that you either import each .sql file into phpmyadmin using the "IMPORT" tab, which runs the script when you press the [GO] button. Alternatively ; cut n paste the text from the .sql file into the box under the "SQL" tab. this will run the script when you press [GO]. However: I get this BS when I run either way, the [downloads_controller_english.sql ] file. Error SQL query: #NEW FIELDS FOR DOWNLOADS CONTROLLER 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 ( '', 'Downloads Controller Update Status Value', 'DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE', '12', 'What orders_status resets the Download days and Max Downloads - Default is 12', '13', '90', '2003-02-18 13:22:32', '', NULL , NULL ); MySQL said: Documentation #1046 - No database selected http://www.oscommerce.com/forums/style_images/ip.boardpr/folder_post_icons/icon13.gif Hmmmm ... no data base selected... I guess that, in my case is "commerce_db" or is it the mySQL database? AND how do I select it? With "new_files" you just drag n drop the files to the appropriate folders as duplicated in the contribution release. With "modified_files" you need to copy the text contained within the modified files, and paste that text at the described location within the file of the same name in the same appropriate folders as duplicated in the contribution release.... unless I am very much mistaken. So how do I select the appropriate database so the SQL script will run?http://www.oscommerce.com/forums/style_images/ip.boardpr/folder_post_icons/icon14.gif Cheers
  6. Hello all, I'm new at the osC game and am just learning things as I go. I have not uploaded to my host site yet and am developing on my localhost. One thing has become obvious to me . There seems to be quite a number of posts on this topic here dating back to 2003. Much of the problem seems to be with compatibility with other contrib installs. This is the nature of the beast I gues, and of course I realise that some contribs take a lot of development time by some dedicated and very wised up people, all done foc. But , I think that if osC is going to survive as Open source product that people can actually use, a few things need to change with the initial osCommerce Online Merchant v2.x download package. 1. more functions (contributions) that have been tested and installed in the correct order as to eliminate code conflicts of one contrib to another. 2. It needs a contribution installer , with an automated backup routine, As started by Vlad Savitsky. ALL contributions should be then written in the same format, to be installed by the supplied, contribution installer. Vlad Savitsky has now dropped development of his installer contribution and is using another package. Yes , this is the down side of open source. One either has time or money, rarely both. Sadly I dont have either, and really need to find a faster way to get my site up and running. Well done to everyone that has made osCommerce what it is. I will hang in there, but this is not for the non-programmers like myself. I think that if someone can come up with a method of seamlessly adding contribution modules, the time taken to get osCommerce running sweet will be greatly reduced. Sadly I aint that guy. Best wishes to all.
×
×
  • Create New...