Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[SUPPORT] HTML Editor and UltraPics by MaxiDVD


Guest

Recommended Posts

@ Matt

 

Same as mine. It is a mySQL Database Problem. The sql_file.sql file isnt executed properly, read my post above. ill test it now.

Link to comment
Share on other sites

  • Replies 474
  • Created
  • Last Reply

Top Posters In This Topic

@ Matt

 

Same as mine. It is a mySQL Database Problem. The sql_file.sql file isnt executed properly, read my post above. ill test it now.

Great now what can I do to fix this? This is all new to me.

Knowledge is Power!

Link to comment
Share on other sites

: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 !

Link to comment
Share on other sites

I met a new problem:

 

when I add a new product, I use PHP Image Manager to upload an image to a sub-directory, then manually type the directory/file (e.g. group/prod.jpg) in image field, when I click preview, the image cannot be shown, it adds

<P></P>

pair in the url, the image is mistaken as

http://www.xxx.com/images/<P>group/prod.jpg</P>

so it won't be shown.

Link to comment
Share on other sites

: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?

Knowledge is Power!

Link to comment
Share on other sites

If you all have errors, this means you have doubled tables becouse u tryed it to often. you have to have a clear new database or (what i did) delete double entrys from your database.

 

I had everything five times becouse i inserted the buggy sql data multiple times as nothing happend.

 

After Deleting doubles inside of "configuration" (not "configuration_group") my site worked perfect and the mod is realy eyecandy !!!

Link to comment
Share on other sites

using this contribution with Mac OSX 10.3.3

 

I wonder if I'm the only mac person trying to use this contribution? I have discovered a couple of problems by comparing what I see when running on my mac, and what my mentor sees when he edits the same shop on Windows:

 

A. the HTML text edit toolbar doesn't appear on mac

B. the pic upload manager doesn't appear on mac - the little click on me box thingy in the product area is missing. I can however manually input the location of a pic and it will upload succesfully.

 

The mac is running the latest version of everything - IE (5.2.3), OS 10.3.3. I have also tried it with Safari (latest version), same problem.

 

1. Does anyone have any solutions. It makes for very slow going without those added features.

 

2. Does anyone know what other features are 'disabled' on mac?

 

Please no windows vs mac flames; constructive comments only.

Link to comment
Share on other sites

Hi Everyone,

 

I have the contribution installed and I'm having a problem with selecting images. Everytime I try to choose an image for a product I get the following error and it will not select the image. I can view the images when selecting them on the left site (they appear on the right) but when I choose ok I only get "http://" in the box where the image url should be. If I manually type in the url to the image it will still show as broken when previewing.

 

Any Suggestions?

 

error.gif

Link to comment
Share on other sites

I've installed the UltraPics - MS2 Image Addon Pack! (1642) and I'm getting the following when I open the image manager.

 

picture1.jpg

 

I'm also getting the security warning about nonsecure information when I try to access any page that has the wysiwyg editor enabled.  I'm using a shared SSL through iPowerWeb.

 

The link to the store is http://www.highlandlakestackle.com/catalog

 

The link to the SSL is https://host101.ipowerweb.com/~highland/catalog

 

What am I missing here?

I have the same problem. I am on a shared host and using SSL. The SSL works in my case by mapping the whole directory structure and data to the secure server. When I access using http it all works fine, when I switch to https, I get the problems described above. Any ideas?

 

I have noticed that

 

  _editor_url = "<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_ADMIN; ?>htmlarea/";  // URL to htmlarea files

 

is used alot (categories.php for one), but I can't see where $request_type is declared. I don't think this is causing my problems, as I set both the HTTPS_SERVER and the HTTP_SERVER to my secure server and vice versa.

 

Jondab-Ali suggests (http://www.oscommerce.com/forums/index.php?showtopic=72486&st=0&) that on a shared host, using SSL, you should use the following.

 

Ok, got it fixed.  :D

 

The fix for oneandone hosting with shared SSL is as follows:

 

backup your /includes/application_top.php by making a duplicate copy.

 

edit your /includes/application_top.php

 

Find this code (at around line 41):

// set the type of request (secure or not)
 $request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL';

 

Comment out the existing getenv() command with "//" and add the following one, like so:

 

// set the type of request (secure or not)
//  $request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL';
 $request_type = (eregi ($HTTP_HOST, HTTPS_SERVER)) ? 'SSL' : 'NONSSL';

 

Make sure you haven't got any spare lines after the last "?>" line on the page.

 

Save the file, upload it (overwrite the old file in /includes/).

 

Try your checkout now.

 

Hope this works for you, too.  B)

 

Thanks to Emerson in this thread for the fix.

 

Peace.

 

This fix works for me, in that it correctly determines the request_type. I wonder if there is something similar going on elsewhere, that's causing this problem?

 

cheers

Simon

Link to comment
Share on other sites

I've sorted my main problem with the image viewer. This solution maybe of interest to others who are using a shared ssl site to access their admin area. If your normal url is http://www.mybusiness.co.uk and you are using a shared ssl server, you are generally given a sub-directory on the shared ssl server e.g. https://www.securesite.co.uk/mybusiness. It was this extra directory and a "http://" which were causing my problems.

 

In admin/htmlarea/popups/file/config.inc.php at lines 291 and 400, the following is used in scriptURL() and imageURL()

 

  // return the URL
  return ("http://" . $HTTP_SERVER_VARS["HTTP_HOST"] . $url);

 

For this example $HTTP_SERVER_VARS["HTTP_HOST"] gives www.securesite.co.uk and not the directory that most of us need if using a shared SSL. With this in mind make sure that your defines in admin/configure.php are set correctly. In particular, scriptURL() and imageURL(), use the following defines to find the image directory.

 

define("IMAGE_DIR", trim(DIR_FS_CATALOG . DIR_WS_IMAGES));

define("IMAGE_URL", trim(DIR_WS_CATALOG_IMAGES));

 

so make sure that there are correct. Also note the http:// and not https://, you will also need to change this. I hope this helps.

 

cheers

Simon

Link to comment
Share on other sites

Hi...can you tell me if there is a way to add php code to the html editor? If so...what can i do to make it work. I have the newest version isntalled, but each time i enter in php coding, it doesn't listen to the tag.. it just shows me blank space.

 

Any ideas would be appreciated :)

Link to comment
Share on other sites

To fix admin/htmlarea/popups/file/config.inc.php at lines 291 and 400, for shared ssl (see above post), you can add the following...

 

replace:

 

return ("http://" . $HTTP_SERVER_VARS["HTTP_HOST"] . $url);

 

with:

 

return ( ((getenv('HTTPS') == 'on' or getenv('SERVER_PORT') == 443) ? "https://" : "http://") . $HTTP_SERVER_VARS["HTTP_HOST"] . $url);

 

cheers

Simon

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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!!!

Knowledge is Power!

Link to comment
Share on other sites

And all for Free :D Send me an handmade Coyote Singing Buckle :D

 

And dont forget to define the Filename FILENAME_DEFINE_MAINPAGE witch is "define_mainpage.php" :D

Link to comment
Share on other sites

Hi!

 

I got still a problem with the fixed MY SQL Script of 'Your Mother'...

 

Error

 

SQL-Command: 

 

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'

)

 

MySQL says:

 

 

#1062 - Duplicate entry '112' for key 1

 

What does it mean?

 

And i got a second problem: if i click on a product image to enlarge it, the popup which opens is empty... :-(

 

Maybe because of the SQL Error??

 

Thank you!

 

Nicao

Link to comment
Share on other sites

Hi!

 

I got still a problem with the fixed MY SQL Script of 'Your Mother'...

 

Error

 

SQL-Command:?

 

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'

)

 

MySQL says:

 

 

#1062 - Duplicate entry '112' for key 1

 

What does it mean?

 

And i got a second problem: if i click on a product image to enlarge it, the popup which opens is empty... :-(

 

Maybe because of the SQL Error??

 

Thank you!

 

Nicao

U already have this entry.

Link to comment
Share on other sites

Hi YourMother!

 

Thank you ;)

I already thought something like this *g*

 

But can you imagine why the popup doesnt work? everything else works great...

 

I got no idea, i checked all files for chmod and rewrited them... :(

 

Nicao

Link to comment
Share on other sites

#1062 - Duplicate entry '112' for key 1

 

You have allready insertet the sql file once..

go to datebase --> configuration_group ---> configuration_group_id klick onit

( show) look for

112 WYSIWYG Editor 1.7 HTMLArea 1.7 Options -----Delete it-----

 

Take the fixed sql file and run it again

Link to comment
Share on other sites

Hi

i have tried a few times to update the database with the sql file a couple of pages ago but come up with this error:

Error

SQL-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 (
'', '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\'))'
)

MySQL said:

Column 'configuration_value' cannot be null

 

how can i fix this please?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...