Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MattMallory

Members
  • Content count

    132
  • Joined

  • Last visited

Posts posted by MattMallory


  1. tonystewart, did you ever get the PayPal subscriptions to carry to the cart? We want to sell our hosting on a recurring basis via OSC but we also want to sell other products that are one time sales & I think your future contrib will do this for us. Let me know, thanks.


  2. This contribution works perfectly well all you need to do is read the install and follow the instructions

     

    if you are getting errors it is becuase you have missed something out and admittedly this install process needs to be done one step at a time just be careful

     

    Andrew

    What directions are there to follow? Copy the files over & run the sql query! Not that hard. I have repeated the steps like 4 times & have the same errors so not sure how it could be me. Any suggestions on how to fix the problems are welcome.


  3. Warning: main(includes/languages/english/FILENAME_DEFINE_MAINPAGE): failed to open stream: No such file or directory in /home/factorie/public_html/store/index.php on line 307

     

    Warning: main(): Failed opening 'includes/languages/english/FILENAME_DEFINE_MAINPAGE' for inclusion (include_path='.:/usr/local/lib/php') in /home/factorie/public_html/store/index.php on line 307

    Where did you find the fix for this? I can not find it for the life of me. <_<


  4. To sum up all the bugs I found in this contrib on a fresh install of 2.2 MS2...

     

    1) The UltraPics part of this contrib is not showing up at all.

     

    2) The WYSIWYG Editor 1.7 link is not showing up under Configuration like it should.

     

    3) The WYSIWYG icons are not showing up above any of the editable text boxes.

     

    4) In Admin > Tools the links below are not showing up correctly.

     

    BOX_CATALOG_DEFINE_MAINPAGE

    BOX_INFORMATION_MANAGER

     

    FIXED - 5) The information table is missing from the database. Thanks to another member I had to insert code to add the table so the site came up correctly!

     

    If anyone can tell me how to fix these errors in this contrib please let me know, thanks.


  5. in my admin_section i see the word:

    BOX_CATALOG_DEFINE_MAINPAGE

    which is clickable and does show a window on the right side into which content can be changed but the word above does not seem to display right.

    Did you ever find a fix for this? I also have BOX_INFORMATION_MANAGER showing up wrong.


  6. Ok, I fixed this. Had the problem before & someone helped me to fix it. You think this bug will be fixed in the next update MaxiDVD?

     

    Have another problem that no one seems to know how to fix yet...

    In Admin > Tools the links below have issues. Anyone know what the problem is? As I said this is a fresh install.

     

    BOX_CATALOG_DEFINE_MAINPAGE

    BOX_INFORMATION_MANAGER


  7. I looked & I might have missed the fix for this but I am getting the below error in the Information box...

     

    Table 'was_osc1.information' doesn't exist

     

    & the rest of the page will not load. This happened after installing "image_html_package_1.2 form 10 Mar 2004" on a fresh install of 2.2 MS2 in the root (not in a directory). Can anyone tell me how to fix this please?


  8. I have thebelow errors. Does anyone know what I can do to fix them? Thanks in advance!

     

    1) The main page does not load & this is the error I get:

    Table 'handmade_osc1.information' doesn't exist

     

    2) DEFINE MAINPAGE link in the admin reads as:

    "BOX_CATALOG_DEFINE_MAINPAGE"

     

    3) Under Tools in Admin I have these 2 new links...

    BOX_CATALOG_DEFINE_MAINPAGE links to the same page as #3 does. Why is it in the admin 2 times & how do I fix it so the link displays right?

     

    BOX_INFORMATION_MANAGER gives me the below error which is the same one that is on the home page...

    Information ERROR: Table 'handmade_osc1.information' doesn't exist

    I guess, your not using english as default. You need to define the BOX_CATALOG_DEFINE_MAINPAGE and the BOX_CATALOG_DEFINE_MAINPAGE variables in any language file to any text you like.

     

    to 1)

     

    Information ?
    Table 'handmade_osc1.information' doesn't exist

     

    this seems to be also an database error, maybe the entrys are wrong or you even dont have the "information" table witch i think, is your problem.

     

    Try to delete the Table information if it exists, and insert this into your db:

     

    #

    # Table structure `information`

    #

     

    DROP TABLE IF EXISTS information;

    CREATE TABLE information (

    information_id tinyint(3) unsigned NOT NULL auto_increment,

    visible decimal(1,0) NOT NULL DEFAULT '1',

    v_order tinyint(3) unsigned NOT NULL DEFAULT '0',

    info_title varchar(255) NOT NULL DEFAULT '',

    description text NOT NULL,

    languages_id int(11) DEFAULT '0' NOT NULL,

     

    PRIMARY KEY (information_id,languages_id)

    ) TYPE=MyISAM;

    AWESOME!!!! I did not have an information table so I just went ahead & added that code to the database & it seems to have fixed it! THANK YOU!!!


  9. :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol:

     

     

    BINGO !! Ive got it !!

     

    Use this MySQL as follows. He had several Bugs in his mySQL Dump, most of them was missing appostrophes ' ' around the values and some syntax errors by closing this ones ))) and he used incompatible array syntax like enum(1,0)

     

    I repaired it and i made it compatible with myAdmin 2.5.6. Copy the Text and insert it in your database, if an error says, "table exists" you have to re copy the sql text just one line after that one, that causes the error and insert it again.

     

    Im not responsible what this is doing to your data or database, use it on your own risk:

     

    # NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2

    # HTML_WYSIWYG_SQL.sql

    # Created by: MaxiDVD www.maxidvd.com.au

     

    INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1');

     

    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 ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', '112', '0', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

     

    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 ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', '112', '10', now(), now(),NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'))');

     

    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 ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', '112', '15', now(), now(),NULL, '');

    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 ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', '112', '19', now(), now(),NULL, '');

     

    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 ('', 'DEFINE MAINPAGE use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_DEFINE', 'Enable', 'Use WYSIWYG Area in Define Mainpage', '112', '25', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

    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 ('', 'Define Mainpage Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_DEFINE', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', '112', '29', now(), now(),NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'))');

    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 ('', 'Define Mainpage Layout Width', 'DEFINE_MAINPAGE_WYSIWYG_WIDTH', '605', 'How WIDE should the HTMLAREA be in pixels (default: 505)', '112', '35', now(), now(),NULL, '');

    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 ('', 'Define Mainpage Layout Height', 'DEFINE_MAINPAGE_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', '112', '41', now(), now(),NULL, '');

     

    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 ('', 'INFORMATION PAGES UNLIMITED use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_IPU', 'Enable', 'Use WYSIWYG Area in Information Pages', '112', '44', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

    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 ('', 'Information Pages Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_IPU', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', '112', '48', now(), now(),NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'))');

    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 ('', 'Information Pages Layout Width', 'HTML_AREA_WYSIWYG_WIDTH_IPU', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', '112', '51', now(), now(),NULL, '');

    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 ('', 'Information Pages Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT_IPU', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', '112', '54', now(), now(),NULL, '');

     

    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 ('', 'CUSTOMER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_EMAIL', 'Enable', 'Use WYSIWYG Area in Email Customers', '112', '59', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

    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 ('', 'Customer Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_EMAIL', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', '112', '62', now(), now(),NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'))');

    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 ('', 'Customer Email Layout Width', 'EMAIL_AREA_WYSIWYG_WIDTH', '550', 'How WIDE should the HTMLAREA be in pixels (default: 505)', '112', '66', now(), now(),NULL, '');

    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 ('', 'Customer Email Layout Height', 'EMAIL_AREA_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', '112', '69', now(), now(),NULL, '');

     

    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 ('', 'NEWSLETTER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_NEWSLETTER', 'Enable', 'Use WYSIWYG Area in Email Newsletter', '112', '72', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

    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 ('', 'Newsletter Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_NEWSLETTER', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', '112', '75', now(), now(),NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'))');

    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 ('', 'Newsletter Email Layout Width', 'NEWSLETTER_EMAIL_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', '112', '77', now(), now(),NULL, '');

    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 ('', 'Newsletter Email Layout Height', 'NEWSLETTER_EMAIL_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', '112', '79', now(), now(),NULL, '');

     

    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 ('', 'GLOBAL - User Interface (GUI) Font Type', 'HTML_AREA_WYSIWYG_FONT_TYPE', 'Times New Roman', 'User Interface Font Type<br>(not saved to product description)', '112', '82', now(), now(),NULL, 'tep_cfg_select_option(array(\'Arial\', \'Courier New\', \'Georgia\', \'Impact\', \'Tahoma\', \'Times New Roman\', \'Verdana\', \'Wingdings\'))');

    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 ('', 'GLOBAL - User Interface (GUI) Font Size', 'HTML_AREA_WYSIWYG_FONT_SIZE', '12', 'User Interface Font Size (not saved to product description)<p><b>10 Equals 10 pt', '112', '84', now(), now(),NULL, 'tep_cfg_select_option(array(\\\'8\\\', \\\'10\\\', \\\'12\\\', \\\'14\\\', \\\'18\\\', \\\'24\\\', \\\'36\\\'))');

    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 ('', 'GLOBAL - User Interface (GUI) Font Colour', 'HTML_AREA_WYSIWYG_FONT_COLOUR', 'Black', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or HTML colour code!<br>(not saved to product description)', '112', '86', now(), now(),NULL, '');

    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 ('', 'GLOBAL - User Interface (GUI) Background Colour', 'HTML_AREA_WYSIWYG_BG_COLOUR', 'White', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or html colour code!<br>(not saved to product description)', '112', '89', now(), now(),NULL, '');

    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 ('', 'GLOBAL - ALLOW DEBUG MODE?', 'HTML_AREA_WYSIWYG_DEBUG',NULL, 'Moniter Live-html, It updates as you type in a 2nd field above it.<p>Disable Debug = 0<br>Enable Debug = 1<br>Default = 0 OFF', '112', '91', now(), now(),NULL, 'tep_cfg_select_option(array(\'0\', \'1\'))');

     

    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 Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'Enable', 'Display Additional Images below Product Description?', '4', '20', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

    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 PHP Image Manager?', 'WYSIWYG_USE_PHP_IMAGE_MANAGER', 'Enable', 'Enable/Disable PHP Ultra-Image Manger?', '4', '21', now(), now(),NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'))');

    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 ('', 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '140', 'The pixel width of additional thumb images', '4', '23', now(), now(),NULL,NULL);

    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 ('', 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '120', 'The pixel height of additional thumb images', '4', '25', now(), now(),NULL,NULL);

    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 ('', 'Medium Image Width', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', '4', '28', now(), now(),NULL,NULL);

    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 ('', 'Medium Image Height', 'MEDIUM_IMAGE_HEIGHT', '200', 'The pixel height of medium images', '4', '30', now(), now(),NULL,NULL);

    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 ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', '', 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', '4', '32', now(), now(),NULL,NULL);

    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 ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', '', 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', '4', '35', now(), now(), '0', '0');

     

    ALTER TABLE products ADD products_image_med VARCHAR(64) AFTER products_image;

    ALTER TABLE products ADD products_image_lrg VARCHAR(64) AFTER products_image_med;

    ALTER TABLE products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg;

    ALTER TABLE products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1;

    ALTER TABLE products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1;

    ALTER TABLE products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2;

    ALTER TABLE products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2;

    ALTER TABLE products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3;

    ALTER TABLE products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3;

    ALTER TABLE products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4;

    ALTER TABLE products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4;

    ALTER TABLE products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5;

    ALTER TABLE products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5;

    ALTER TABLE products ADD products_image_xl_6 VARCHAR(64) AFTER products_image_sm_6;

     

    #

    # Table structure `information`

    #

     

    DROP TABLE IF EXISTS information;

    CREATE TABLE information (

    ? information_id tinyint(3) unsigned NOT NULL auto_increment,

    ? visible decimal(1,0) NOT NULL DEFAULT '1',

    ? v_order tinyint(3) unsigned NOT NULL DEFAULT '0',

    ? info_title varchar(255) NOT NULL DEFAULT '',

    ? description text NOT NULL,

    ? languages_id int(11) DEFAULT '0' NOT NULL,

     

    ? PRIMARY KEY? (information_id,languages_id)

    ) TYPE=MyISAM;

     

    Good Luck !

    Sorry for the dumb ? but how do I use it? Do I just import it into the database?


  10. I have thebelow errors. Does anyone know what I can do to fix them? Thanks in advance!

     

    1) The main page does not load & this is the error I get:

    Table 'handmade_osc1.information' doesn't exist

     

    2) DEFINE MAINPAGE link in the admin reads as:

    "BOX_CATALOG_DEFINE_MAINPAGE"

     

    3) Under Tools in Admin I have these 2 new links...

    BOX_CATALOG_DEFINE_MAINPAGE links to the same page as #3 does. Why is it in the admin 2 times & how do I fix it so the link displays right?

     

    BOX_INFORMATION_MANAGER gives me the below error which is the same one that is on the home page...

    Information ERROR: Table 'handmade_osc1.information' doesn't exist


  11. Let me refrase that. Changing the define_mainpage.php to mainpage.php ONLY fixed #2 which was the below. I still have errors 1, 3 & 4 which I have relisted below if anyone has an idea on what I can do to fix this. Thanks in advance!

     

    1) The main page does not load & this is the error I get:

    Table 'handmade_osc1.information' doesn't exist

     

    2) FIXED! = Warning: main(): Failed opening 'includes/languages/english/mainpage.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/handmade/public_html/catalog/index.php on line 307

     

    3) DEFINE MAINPAGE link in the admin reads as "BOX_CATALOG_DEFINE_MAINPAGE"

     

    4) Under Tools in Admin I have these 2 new links...

    BOX_CATALOG_DEFINE_MAINPAGE links to the same page as #3 does. Why is it in the admin 2 times?

     

    BOX_INFORMATION_MANAGER gives me the below error which is the same one that is on the home page...

    Information ERROR: Table 'handmade_osc1.information' doesn't exist


  12. What no one knows why I am getting the below errors?

     

    Warning: main(includes/languages/english/mainpage.php): failed to open stream: No such file or directory in /home/wcm/public_html/index.php on line 307
    
    Warning: main(): Failed opening 'includes/languages/english/mainpage.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/wcm/public_html/index.php on line 307


  13. I found an error in the sql file, there were 4 missing quotes. the attached is the updated sql file.

    # NEW RECORDS FOR: WYSIWYG HTML AREA 1.7 and ULTRA IMAGES for MS2
    # HTML_WYSIWYG_SQL.sql
    # Created by: MaxiDVD www.maxidvd.com.au
    
    INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1');
    
    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 ('', 'PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 ('', 'Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
    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 ('', 'Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, now(), now(), NULL, '');
    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 ('', 'Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, now(), now(), NULL, '');
    
    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 ('', 'DEFINE MAINPAGE use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_DEFINE', 'Enable', 'Use WYSIWYG Area in Define Mainpage', 112, 25, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 ('', 'Define Mainpage Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_DEFINE', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 29, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
    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 ('', 'Define Mainpage Layout Width', 'DEFINE_MAINPAGE_WYSIWYG_WIDTH', '605', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 35, now(), now(), NULL, '');
    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 ('', 'Define Mainpage Layout Height', 'DEFINE_MAINPAGE_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 41, now(), now(), NULL, '');
    
    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 ('', 'INFORMATION PAGES UNLIMITED use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_IPU', 'Enable', 'Use WYSIWYG Area in Information Pages', 112, 44, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 ('', 'Information Pages Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_IPU', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 48, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
    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 ('', 'Information Pages Layout Width', 'HTML_AREA_WYSIWYG_WIDTH_IPU', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 51, now(), now(), NULL, '');
    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 ('', 'Information Pages Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT_IPU', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 54, now(), now(), NULL, '');
    
    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 ('', 'CUSTOMER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_EMAIL', 'Enable', 'Use WYSIWYG Area in Email Customers', 112, 59, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 ('', 'Customer Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_EMAIL', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 62, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
    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 ('', 'Customer Email Layout Width', 'EMAIL_AREA_WYSIWYG_WIDTH', '550', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 66, now(), now(), NULL, '');
    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 ('', 'Customer Email Layout Height', 'EMAIL_AREA_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 69, now(), now(), NULL, '');
    
    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 ('', 'NEWSLETTER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_NEWSLETTER', 'Enable', 'Use WYSIWYG Area in Email Newsletter', 112, 72, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 ('', 'Newsletter Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_NEWSLETTER', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 75, now(), now(), NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
    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 ('', 'Newsletter Email Layout Width', 'NEWSLETTER_EMAIL_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 77, now(), now(), NULL, '');
    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 ('', 'Newsletter Email Layout Height', 'NEWSLETTER_EMAIL_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 79, now(), now(), NULL, '');
    
    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 ('', 'GLOBAL - User Interface (GUI) Font Type', 'HTML_AREA_WYSIWYG_FONT_TYPE', 'Times New Roman', 'User Interface Font Type<br>(not saved to product description)', 112, 82, now(), now(), NULL, 'tep_cfg_select_option(array(\'Arial\', \'Courier New\', \'Georgia\', \'Impact\', \'Tahoma\', \'Times New Roman\', \'Verdana\', \'Wingdings\'),');
    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 ('', 'GLOBAL - User Interface (GUI) Font Size', 'HTML_AREA_WYSIWYG_FONT_SIZE', '12', 'User Interface Font Size (not saved to product description)<p><b>10 Equals 10 pt', 112, 84, now(), now(), NULL, 'tep_cfg_select_option(array(\\\'8\\\', \\\'10\\\', \\\'12\\\', \\\'14\\\', \\\'18\\\', \\\'24\\\', \\\'36\\\'),');
    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 ('', 'GLOBAL - User Interface (GUI) Font Colour', 'HTML_AREA_WYSIWYG_FONT_COLOUR', 'Black', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or HTML colour code!<br>(not saved to product description)', 112, 86, now(), now(), NULL, '');
    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 ('', 'GLOBAL - User Interface (GUI) Background Colour', 'HTML_AREA_WYSIWYG_BG_COLOUR', 'White', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or html colour code!<br>(not saved to product description)', 112, 89, now(), now(), NULL, '');
    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 ('', 'GLOBAL - ALLOW DEBUG MODE?', 'HTML_AREA_WYSIWYG_DEBUG', '0', 'Moniter Live-html, It updates as you type in a 2nd field above it.<p>Disable Debug = 0<br>Enable Debug = 1<br>Default = 0 OFF', 112, 91, now(), now(), NULL, 'tep_cfg_select_option(array(\'0\', \'1\'),');
    
    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 Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'Enable', 'Display Additional Images below Product Description?', 4, 20, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 PHP Image Manager?', 'WYSIWYG_USE_PHP_IMAGE_MANAGER', 'Enable', 'Enable/Disable PHP Ultra-Image Manger?', 4, 21, now(), now(), NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
    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 ('', 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '140', 'The pixel width of additional thumb images', 4, 23, now(), now(), NULL, NULL);
    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 ('', 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '120', 'The pixel height of additional thumb images', 4, 25, now(), now(), NULL, NULL);
    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 ('', 'Medium Image Width', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', 4, 28, now(), now(), NULL, NULL);
    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 ('', 'Medium Image Height', 'MEDIUM_IMAGE_HEIGHT', '200', 'The pixel height of medium images', 4, 30, now(), now(), NULL, NULL);
    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 ('', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now(), now(), NULL, NULL);
    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 ('', 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', , 'The pixel height of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 35, now(), now(), NULL, NULL);
    
    ALTER TABLE products ADD products_image_med VARCHAR(64) AFTER products_image;
    ALTER TABLE products ADD products_image_lrg VARCHAR(64) AFTER products_image_med;
    ALTER TABLE products ADD products_image_sm_1 VARCHAR(64) AFTER products_image_lrg;
    ALTER TABLE products ADD products_image_xl_1 VARCHAR(64) AFTER products_image_sm_1;
    ALTER TABLE products ADD products_image_sm_2 VARCHAR(64) AFTER products_image_xl_1;
    ALTER TABLE products ADD products_image_xl_2 VARCHAR(64) AFTER products_image_sm_2;
    ALTER TABLE products ADD products_image_sm_3 VARCHAR(64) AFTER products_image_xl_2;
    ALTER TABLE products ADD products_image_xl_3 VARCHAR(64) AFTER products_image_sm_3;
    ALTER TABLE products ADD products_image_sm_4 VARCHAR(64) AFTER products_image_xl_3;
    ALTER TABLE products ADD products_image_xl_4 VARCHAR(64) AFTER products_image_sm_4;
    ALTER TABLE products ADD products_image_sm_5 VARCHAR(64) AFTER products_image_xl_4;
    ALTER TABLE products ADD products_image_xl_5 VARCHAR(64) AFTER products_image_sm_5;
    ALTER TABLE products ADD products_image_sm_6 VARCHAR(64) AFTER products_image_xl_5;
    ALTER TABLE products ADD products_image_xl_6 VARCHAR(64) AFTER products_image_sm_6;
    
    #
    # Table structure `information`
    #
    
    DROP TABLE IF EXISTS information;
    CREATE TABLE information (
    ?information_id tinyint(3) unsigned NOT NULL auto_increment,
    ?visible enum('1','0') NOT NULL default '1',
    ?v_order tinyint(3) unsigned NOT NULL default '0',
    ?info_title varchar(255) NOT NULL default '',
    ?description text NOT NULL,
    ?languages_id int(11) DEFAULT '0' NOT NULL,
    
    ?PRIMARY KEY ?(information_id,languages_id)
    ) TYPE=MyISAM;

    What problems do the missing quotes cause?

×