Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

NewsDesk v1.48 Support


241

Recommended Posts

  • Replies 548
  • Created
  • Last Reply

Top Posters In This Topic

byps

 

I do not use STS in any install that I do, so cannot help in that respect, I would suggest that you try posting in the STS support thread where there are more people that use STS. RI Downlink I believe uses STS and has the Newsdesk working without issue

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

noidwerx

 

Where you mention url naming. What part were you thinking off as at present you can in the next release name the weblinks that appear in the article to replace the word webpage with the actual name of the url and in the admin preview you will see the name of the actual link rather than webpage

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Hi there,

 

I have just installed the NEWSDESK and have the following error in admin, when I click on NEWSDESK:

 

1146 - Table 'simplici_oscommerce.TABLE_NEWSDESK_CONFIGURATION_GROUP' doesn't exist

 

select configuration_group_id as cgID, configuration_group_title as cgTitle from TABLE_NEWSDESK_CONFIGURATION_GROUP where visible = '1' order by sort_order

 

[TEP STOP]

 

Can you please advise on this!

 

Thanks!

Edited by ][v][on$ter
Link to comment
Share on other sites

][v][on$ter

 

Your error says that the table does not exist.

Have you ran the sql on the database.

Verify that your newsdesk tables exist on the database.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

][v][on$ter

 

Your error says that the table does not exist.

Have you ran the sql on the database.

Verify that your newsdesk tables exist on the database.

I ran the SQL twice! What do you suggest i do?

It displays the error in the admin column_right.php

Edited by ][v][on$ter
Link to comment
Share on other sites

:o How about my problem?

How about my problem is not offering any information on an issue that resides in your setup that I do not have access to, so have to rely on what information you give, however you do not give information unless poked and proded into giving information.

 

I have asked you a number of questions and you have given answers of yes, this sort of answer gives very little information.

 

I have also told you that your issue is with an earlier version of Newsdesk and whatever fixes you implimented then.

 

I am not a mind reader and if you cannot begin to help yourself then how is it that you can ask of me for help.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Your SQL-query has been executed successfully

 

SQL-query : [Edit] [Create PHP Code]

DROP TABLE IF EXISTS newsdesk;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk(

newsdesk_id int( 11 ) NOT NULL AUTO_INCREMENT ,

newsdesk_image varchar( 64 ) default NULL ,

newsdesk_image_two varchar( 64 ) default NULL ,

newsdesk_image_three varchar( 64 ) default NULL ,

newsdesk_date_added datetime NOT NULL default '0000-00-00 00:00:00',

newsdesk_last_modified datetime default NULL ,

newsdesk_date_available datetime default NULL ,

newsdesk_status tinyint( 1 ) NOT NULL default '0',

newsdesk_sticky tinyint( 1 ) NOT NULL default '1',

PRIMARY KEY ( newsdesk_id ) ,

KEY idx_newsdesk_date_added( newsdesk_date_added )

) TYPE = MYISAM AUTO_INCREMENT =4;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk( newsdesk_id, newsdesk_image, newsdesk_image_two, newsdesk_image_three, newsdesk_date_added, newsdesk_last_modified, newsdesk_date_available, newsdesk_status, newsdesk_sticky )

VALUES ( 1, 'newsdesk_test_osc_sticky.gif', '', '', '2003-03-10 02:32:00', '2004-05-12 14:09:14', NULL , 1, 1 ) , ( 2, 'newsdesk_test_osc_thanks.gif', '', '', '2003-03-10 02:40:20', '2004-05-14 17:30:43', NULL , 1, 0 ) , ( 3, 'newsdesk_test_osc_action.gif', 'newsdesk_test_osc_cartoons.gif', 'newsdesk_test_osc_graphic.gif', '2003-03-10 23:40:39', '2004-05-14 17:30:29', NULL , 1, 0 ) ;# Affected rows:3

DROP TABLE IF EXISTS newsdesk_categories;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_categories(

categories_id int( 11 ) NOT NULL AUTO_INCREMENT ,

categories_image varchar( 64 ) default NULL ,

parent_id int( 11 ) NOT NULL default '0',

sort_order int( 3 ) default NULL ,

date_added datetime default NULL ,

last_modified datetime default NULL ,

catagory_status tinyint( 1 ) NOT NULL default '1',

PRIMARY KEY ( categories_id ) ,

KEY idx_categories_parent_id( parent_id )

) TYPE = MYISAM AUTO_INCREMENT =10;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_categories( categories_id, categories_image, parent_id, sort_order, date_added, last_modified, catagory_status )

VALUES ( 1, NULL , 0, 1, '2003-03-10 02:27:32', '2004-05-12 11:29:55', 1 ) , ( 2, NULL , 0, 2, '2003-03-10 02:28:09', '2004-05-12 14:42:55', 1 ) , ( 3, NULL , 0, 4, '2003-03-10 02:28:34', '2004-05-12 14:44:12', 0 ) , ( 4, NULL , 0, 5, '2003-03-10 02:28:58', '2004-05-12 14:43:59', 1 ) , ( 5, NULL , 0, 6, '2003-03-10 12:02:57', '2004-05-12 14:43:39', 1 ) , ( 6, NULL , 5, 1, '2003-03-10 12:03:28', '2004-05-12 12:22:14', 1 ) , ( 7, NULL , 5, 2, '2003-03-10 23:20:06', '2004-05-12 12:23:41', 1 ) , ( 8, NULL , 5, 3, '2003-03-10 23:36:12', '2004-05-12 12:25:20', 1 ) , ( 9, NULL , 0, 3, '2004-05-12 14:42:03', '2004-05-12 14:44:30', 1 ) ;# Affected rows:9

DROP TABLE IF EXISTS newsdesk_categories_description;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_categories_description(

categories_id int( 11 ) NOT NULL default '0',

language_id int( 11 ) NOT NULL default '1',

categories_name varchar( 32 ) NOT NULL default '',

PRIMARY KEY ( categories_id, language_id ) ,

KEY idx_categories_name( categories_name )

) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_categories_description( categories_id, language_id, categories_name )

VALUES ( 1, 1, 'image' ) , ( 1, 2, 'Bild' ) , ( 1, 3, 'imagen' ) , ( 1, 4, 'image' ) , ( 1, 5, 'beeld' ) , ( 2, 1, 'one image' ) , ( 2, 2, 'ein Bild' ) , ( 2, 3, 'una imagen' ) , ( 2, 4, 'une image' ) , ( 2, 5, '??n beeld' ) , ( 3, 1, 'off' ) , ( 3, 2, 'weg von' ) , ( 3, 3, 'de' ) , ( 3, 4, 'outre de' ) , ( 3, 5, 'van' ) , ( 4, 1, 'sticky' ) , ( 4, 2, 'klebrig' ) , ( 4, 3, 'pegajoso' ) , ( 4, 4, 'collant' ) , ( 4, 5, 'kleverig' ) , ( 5, 1, 'nested top' ) , ( 5, 2, 'genistete Oberseite' ) , ( 5, 3, 'tapa jerarquizada' ) , ( 5, 4, 'dessus nich?' ) , ( 5, 5, 'genestelde bovenkant' ) , ( 6, 1, 'nested down one' ) , ( 6, 2, 'genistet hinunter ein' ) , ( 6, 3, 'jerarquizado abajo de uno' ) , ( 6, 4, 'nich? en bas d''un' ) , ( 6, 5, 'genesteld onderaan' ) , ( 7, 1, 'nested down two' ) , ( 7, 2, 'genistet hinunter zwei' ) , ( 7, 3, 'jerarquizado abajo de dos' ) , ( 7, 4, 'nich? en bas de deux' ) , ( 7, 5, 'genesteld onderaan twee' ) , ( 8, 1, 'nested down three' ) , ( 8, 2, 'genistet hinunter drei' ) , ( 8, 3, 'jerarquizado abajo de tres' ) , ( 8, 4, 'nich? en bas de trois' ) , ( 8, 5, 'genesteld onderaan drie' ) , ( 9, 1, 'no image' ) , ( 9, 2, 'kein Bild' ) , ( 9, 3, 'ninguna imagen' ) , ( 9, 4, 'aucune image' ) , ( 9, 5, 'geen beeld' ) ;# Affected rows:45

DROP TABLE IF EXISTS newsdesk_configuration;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_configuration(

configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,

configuration_title varchar( 64 ) NOT NULL default '',

configuration_key varchar( 64 ) NOT NULL default '',

configuration_value varchar( 255 ) NOT NULL default '',

configuration_description varchar( 255 ) NOT NULL default '',

configuration_group_id int( 11 ) NOT NULL default '0',

sort_order int( 5 ) default NULL ,

last_modified datetime default NULL ,

date_added datetime NOT NULL default '0000-00-00 00:00:00',

use_function varchar( 255 ) default NULL ,

set_function varchar( 255 ) default NULL ,

PRIMARY KEY ( configuration_id )

) TYPE = MYISAM AUTO_INCREMENT =38;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_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 ( 1, 'Search Results', 'MAX_DISPLAY_NEWSDESK_SEARCH_RESULTS', '20', 'How many articles do you want to list?', 1, 1, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 2, 'Page Links', 'MAX_DISPLAY_NEWSDESK_PAGE_LINKS', '5', 'Number of links to use for page-sets', 1, 2, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 3, 'Display Headline', 'NEWSDESK_ARTICLE_NAME', '2', 'Do you want to display the headline? (0=disable; 1=enable)', 1, 3, '2004-05-10 13:28:31', '2003-02-16 02:08:36', NULL , NULL ) , ( 4, 'Display Summary', 'NEWSDESK_ARTICLE_SHORTTEXT', '0', 'Do you want to display the summary? (0=disable; \r\n\r\n1=enable)', 1, 4, '2004-05-10 13:28:38', '2003-02-16 02:08:36', NULL , NULL ) , ( 5, 'Display Content', 'NEWSDESK_ARTICLE_DESCRIPTION', '0', 'Do you want to display the content? (0=disable; \r\n\r\n1=enable)', 1, 5, '2004-05-10 13:28:43', '2003-02-16 02:08:36', NULL , NULL ) , ( 6, 'Display Date', 'NEWSDESK_DATE_AVAILABLE', '1', 'Do you want to display the date? (0=disable; 1=enable)', 1, 6, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 7, 'Display URL', 'NEWSDESK_ARTICLE_URL', '0', 'Do you want to display the outside resource URL? (0=disable; \r\n\r\n1=enable)', 1, 7, '2004-05-10 13:28:48', '2003-02-16 02:08:36', NULL , NULL ) , ( 8, 'Display Status', 'NEWSDESK_STATUS', '0', 'Do you want to display the status for the article? (0=disable; \r\n\r\n1=enable)', 1, 8, '2004-05-10 13:28:52', '2003-02-16 02:08:36', NULL , NULL ) , ( 9, 'Display Image 1', 'NEWSDESK_IMAGE', '0', 'Do you want to display image "1" for the article? (0=disable; \r\n\r\n1=enable)', 1, 9, '2004-05-10 13:28:57', '2003-02-16 02:08:36', NULL , NULL ) , ( 10, 'Display Image 2', 'NEWSDESK_IMAGE_TWO', '0', 'Do you want to display image "2" for the article? (0=disable; \r\n\r\n1=enable)', 1, 10, '2004-05-10 13:29:01', '2003-02-16 02:08:36', NULL , NULL ) , ( 11, 'Display Image 3', 'NEWSDESK_IMAGE_THREE', '0', 'Do you want to display image "3" for the article? (0=disable; \r\n\r\n1=enable)', 1, 11, '2004-05-10 13:29:06', '2003-02-16 02:08:36', NULL , NULL ) , ( 12, 'Location of Prev/Next Navigation Bar', 'NEWSDESK_PREV_NEXT_BAR_LOCATION', '3', 'Sets the location of the \r\n\r\nPrev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 1, 12, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 14, 'Display Main News Items', 'MAX_DISPLAY_NEWSDESK_NEWS', '3', 'How many articles do you want to display on the \r\n\r\ntop page?', 2, 1, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 15, 'Latest News Box Counts', 'LATEST_DISPLAY_NEWSDESK_NEWS', '5', 'How many articles do you want to display in the \r\n\r\nLatest News Box?', 2, 2, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 16, 'Display Latest News Box', 'DISPLAY_LATEST_NEWS_BOX', '1', 'Do you want to display the Latest News Box? \r\n\r\n(0=disable; 1=enable)', 2, 3, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 17, 'Display News Catagory Box', 'DISPLAY_NEWS_CATAGORY_BOX', '1', 'Do you want to display the News Catagory Box? \r\n\r\n(0=disable; 1=enable)', 2, 4, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 18, 'Display View Counts', 'DISPLAY_NEWSDESK_VIEWCOUNT', '1', 'Do you want to display View Counts? (0=disable; \r\n\r\n1=enable)', 2, 5, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 19, 'Display Read More', 'DISPLAY_NEWSDESK_READMORE', '1', 'Do you want to display Read More? (0=disable; \r\n\r\n1=enable)', 2, 6, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 20, 'Display Summary', 'DISPLAY_NEWSDESK_SUMMARY', '1', 'Do you want to display the News Summary? (0=disable; \r\n\r\n1=enable)', 2, 7, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 21, 'Display Headline', 'DISPLAY_NEWSDESK_HEADLINE', '1', 'Do you want to display the News Headline? (0=disable; \r\n\r\n1=enable)', 2, 8, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 22, 'Display Date', 'DISPLAY_NEWSDESK_DATE', '1', 'Do you want to display the News Date? (0=disable; 1=enable)', 2, 9, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 23, 'Display Image 1', 'DISPLAY_NEWSDESK_IMAGE', '1', 'Do you want to display image "1" for the article? (0=disable; \r\n\r\n1=enable)', 2, 10, NULL , '2003-03-03 11:59:47', NULL , NULL ) , ( 24, 'Display Image 2', 'DISPLAY_NEWSDESK_IMAGE_TWO', '1', 'Do you want to display image "2" for the article? \r\n\r\n(0=disable; 1=enable)', 2, 11, '2003-03-03 12:08:55', '2003-03-03 11:59:47', NULL , NULL ) , ( 25, 'Display Image 3', 'DISPLAY_NEWSDESK_IMAGE_THREE', '1', 'Do you want to display image "3" for the article? \r\n\r\n(0=disable; 1=enable)', 2, 12, '2003-03-03 12:09:16', '2003-03-03 11:59:47', NULL , NULL ) , ( 26, 'Display Reviews', 'DISPLAY_NEWSDESK_REVIEWS', '1', 'Do you want to display News Reviews? (0=disable; \r\n\r\n1=enable)', 3, 1, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 27, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '10', 'Maximum number of new reviews to display', 3, 2, NULL , '2003-02-16 02:08:36', NULL , NULL ) , ( 28, 'Display Headline', 'STICKY_ARTICLE_NAME', '1', 'Do you want to display the headline? (0=disable; 1=enable)', 4, 1, NULL , '2003-03-02 00:47:21', NULL , NULL ) , ( 29, 'Display Summary', 'STICKY_ARTICLE_SHORTTEXT', '1', 'Do you want to display the summary? (0=disable; 1=enable)', 4, 2, NULL , '2003-03-02 00:47:21', NULL , NULL ) , ( 30, 'Display Content', 'STICKY_ARTICLE_DESCRIPTION', '1', 'Do you want to display the content? (0=disable; \r\n\r\n1=enable)', 4, 3, '2003-03-02 00:49:34', '2003-03-02 00:47:21', NULL , NULL ) , ( 31, 'Display View Counts', 'STICKY_NEWSDESK_VIEWCOUNT', '1', 'Do you want to display View Counts? (0=disable; \r\n\r\n1=enable)', 4, 4, NULL , '2003-03-02 00:47:21', NULL , NULL ) , ( 32, 'Display Read More', 'STICKY_NEWSDESK_READMORE', '1', 'Do you want to display Read More? (0=disable; 1=enable)', 4, 5, NULL , '2003-03-02 00:47:21', NULL , NULL ) , ( 33, 'Display Date', 'STICKY_DATE_ADDED', '1', 'Do you want to display the date? (0=disable; 1=enable)', 4, 6, '2003-03-02 00:49:54', '2003-03-02 00:47:21', NULL , NULL ) , ( 34, 'Display URL', 'STICKY_ARTICLE_URL', '1', 'Do you want to display the outside resource URL? (0=disable; \r\n\r\n1=enable)', 4, 7, '2003-03-02 00:50:28', '2003-03-02 00:47:21', NULL , NULL ) , ( 35, 'Display Image', 'STICKY_IMAGE', '1', 'Do you want to display image "1" for the article? (0=disable; 1=enable)', 4, 8, '2003-03-02 00:50:14', '2003-03-02 00:47:21', NULL , NULL ) , ( 36, 'Display Image 2', 'STICKY_IMAGE_TWO', '1', 'Do you want to display image "2"for the article? (0=disable; \r\n\r\n1=enable)', 4, 9, NULL , '2003-03-03 23:10:34', NULL , NULL ) , ( 37, 'Display Image 3', 'STICKY_IMAGE_THREE', '1', 'Do you want to display image "3" for the article? (0=disable; \r\n\r\n1=enable)', 4, 10, NULL , '2003-03-03 23:10:34', NULL , NULL ) ;# Affected rows:36

DROP TABLE IF EXISTS newsdesk_configuration_group;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_configuration_group(

configuration_group_id int( 11 ) NOT NULL AUTO_INCREMENT ,

configuration_group_title varchar( 64 ) NOT NULL default '',

configuration_group_description varchar( 255 ) NOT NULL default '',

sort_order int( 5 ) default NULL ,

visible int( 1 ) default '1',

PRIMARY KEY ( configuration_group_id )

) TYPE = MYISAM AUTO_INCREMENT =5;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible )

VALUES ( 1, 'Listing Settings', 'Listing Page configuration options', 1, 1 ) , ( 2, 'Frontpage Settings', 'Front Page configuration options', 1, 1 ) , ( 3, 'Reviews Settings', 'Reviews configuration options', 1, 1 ) , ( 4, 'Sticky Settings', 'Reviews configuration options', 1, 1 ) ;# Affected rows:4

DROP TABLE IF EXISTS newsdesk_description;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_description(

newsdesk_id int( 11 ) NOT NULL AUTO_INCREMENT ,

language_id int( 11 ) NOT NULL default '1',

newsdesk_article_name varchar( 64 ) NOT NULL default '',

newsdesk_article_description text,

newsdesk_article_shorttext text,

newsdesk_article_url varchar( 255 ) default NULL ,

newsdesk_article_viewed int( 5 ) default '0',

newsdesk_image_text text,

newsdesk_image_text_two text,

newsdesk_image_text_three text,

PRIMARY KEY ( newsdesk_id, language_id ) ,

KEY newsdesk_article_name( newsdesk_article_name )

) TYPE = MYISAM AUTO_INCREMENT =4;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_description( newsdesk_id, language_id, newsdesk_article_name, newsdesk_article_description, newsdesk_article_shorttext, newsdesk_article_url, newsdesk_article_viewed, newsdesk_image_text, newsdesk_image_text_two, newsdesk_image_text_three )

VALUES ( 1, 1, 'Stickies are here!', 'Stickies have been implemented in v1.48.1<br />\r\n<br />\r\nIs this not a nifty feature?', '<b>Welcome to the Sticky area</b>', '', 9, '', '', '' ) , ( 1, 2, 'Stickies sind hier!', 'Stickies sind in v1.48.1 eingef?hrt worden<br />\r\n<br />\r\nIst dieses nicht eine geschickte Eigenschaft?', '<b>Willkommen zum klebrigen Bereich</b>', '', 0, '', '', '' ) , ( 1, 3, '?Stickies est? aqu?!', 'Stickies se ha puesto en ejecucio''n en v1.48.1<br />\r\n<br />\r\n?Est? esto no una caracter?stica nifty?', '<b>Recepci?n al ?rea pegajosa</b>', '', 0, '', '', '' ) , ( 1, 4, 'Stickies sont ici !', 'Stickies ont ?t? mis en application dans v1.48.1<br />\r\n<br />\r\nEst-ce que c''est pas un dispositif astucieux ?', '<b>Bienvenue au secteur collant</b>', '', 0, '', '', '' ) , ( 1, 5, 'Stickies is hier!', 'Stickies is uitgevoerd in v1.48.1<br />\r\n<br />\r\nIs dit niet een handige eigenschap?', '<b>Onthaal aan het Kleverige gebied</b>', '', 0, '', '', '' ) , ( 2, 1, 'NewsDesk version 1.48.1', '<b>NewsDesk version 1.48.1 RELEASED!</b><br />\r\n<br />\r\nWith the great help of a few brave souls we can all now enjoy a newer and more powerful, flexible, function rich (<i>too rich?</i>) NewsDesk <ul><li>Mulitple images</li><li>Review Approvals</li><li>RSS</li><li>HTML Bar Editing</li><li>Remove Images</li><li>Subtitles for Images</li><li>And of course Stickies</li></ul>I hope that you will enjoy your NewsDesk!', '<b>Welcome to NewsDesk version 1.48.1</b><br /><br /><i>Special thanks to those who helped with Beta Testing!</i>', '', 70, '', '', '' ) , ( 2, 2, 'NewsDesk Version 1.48.1', '<b>NewsDesk Version 1.48.1 FREIGEGEBEN!</b><br />\r\n<br />\r\nMit der gro?en Hilfe einiger tapferer Seelen k?nnen wir alle ein neueres und ein leistungsf?higer jetzt genie?en, flexibel, die Funktion Rich (<i>zu reich?</i>) NewsDesk <ul><li>Mulitple Bilder</li><li>Bericht-Zustimmungen</li><li>RSS</li><li>HTML Stab-Redigieren</li><li>Entfernen Sie Bilder</li><li>Untertitel f?r Bilder</li><li>Und selbstverst?ndlich Stickies</li></ul>Ich hoffe, da? Sie Ihr NewsDesk genie?en!', '<b>Willkommen zu NewsDesk Version 1.48.1</b><br /><br /><i>Spezieller Dank deren, die bei der Betapr?fung halfen!</i>', '', 0, '', '', '' ) , ( 2, 3, 'Versi?n 1.48.1 de NewsDesk', '<b>?Versi?n 1.48.1 de NewsDesk LANZADA!</b><br />\r\n<br />\r\nCon la gran ayuda de algunas almas valientes podemos todos ahora gozar de un m?s nuevo y m?s de gran alcance, flexible, los ricos de la funci?n (<i>demasiado ricos?</i>) NewsDesk <ul><li>Im?genes de Mulitple</li><li>Aprobaciones De la Revisi?n</li><li>RSS</li><li>El Corregir De la Barra del HTML</li><li>Quite Las Im?genes</li><li>Subt?tulos para las im?genes</li><li>Y por supuesto Stickies</li></ul>?Espero que usted goce de su NewsDesk!', '<b>Recepci?n a la versi?n 1.48.1 de NewsDesk</b><br /><br /><i>?Gracias especiales a los que ayudaron con la prueba beta!</i>', '', 0, '', '', '' ) , ( 2, 4, 'Version 1.48.1 de NewsDesk', '<b>La version 1.48.1 de NewsDesk A LIB?R? !</b><br />\r\n<br />\r\nAvec la grande aide de quelques ?mes courageuses nous pouvons tout maintenant appr?cier un plus nouveau et plus puissant, flexible, les riches de fonction (<i>trop riches ?</i>) NewsDesk <ul><li>Images de Mulitple</li><li>Approbations De Revue</li><li>RSS</li><li>?dition De Barre de HTML</li><li>Enlevez Les Images</li><li>Sous-titres pour des images</li><li>Et naturellement Stickies</li></ul>J''esp?re que vous appr?cierez votre NewsDesk !', '<b>Bienvenue ? la version 1.48.1 de NewsDesk</b><br /><br /><i>Mercis sp?ciaux ? ceux qui ont aid? avec le b?ta essai !</i>', '', 0, '', '', '' ) , ( 2, 5, 'NewsDesk versie 1.48.1', '<b>NewsDesk versie VRIJGEGEVEN 1.48.1!</b><br />\r\n<br />\r\nMet de grote hulp van een paar moedige zielen kunnen wij allen van nieuwer en krachtiger nu genieten, flexibel, te rijke functierijken (<i>te rijk?</i>) NewsDesk <ul><li>De beelden van Mulitple</li><li>De Goedkeuring van het overzicht</li><li>RSS</li><li>Het Uitgeven van de Staaf van HTML</li><li>Verwijder Beelden</li><li>Ondertitels voor Beelden</li><li>En natuurlijk Stickies</li></ul>Ik hoop dat u van uw NewsDesk zult genieten!', '<b>Onthaal aan NewsDesk versie 1.48.1</b><br /><br /><i>Speciaal dankzij hen die met het B?ta Testen hielpen!</i>', '', 0, '', '', '' ) , ( 3, 1, '3 images !!!', '<s>3 images</s> !!!<u>NewsDesk version 1.48.1</u> now has the capability to use 3 images <br />\r\n<br />\r\nplus <sub>subtitles</sub>.<sup>Yippe</sup> Is life not grand?', '<b>NOW up to 3 images can be used!!!</b>', '', 63, 'action', 'cartoons', 'graphic' ) , ( 3, 2, '3 Bilder!!!', '<s>3 Bilder</s> !!!<u>NewsDesk Version 1.48.1</u> hat jetzt die F?higkeit, zum von von 3 Bildern plus <sub>Untertitel zu verwenden</sub>.<sup>Yippe</sup> ist das gro?artige Leben nicht?', '<b>JETZT k?nnen bis 3 Bilder verwendet werden!!!</b>', '', 0, '', '', '' ) , ( 3, 3, '?3 im?genes!!!', '<s>?3 im?genes</s> !!!<u>La versi?n 1.48.1 de NewsDesk</u> ahora tiene la capacidad para utilizar 3 im?genes m?s <sub>subt?tulos</sub>.<sup>?Yippe</sup> es vida no magn?fica?', '<b>?cAhora hasta 3 im?genes se pueden utilizar!!!</b>', '', 0, '', '', '' ) , ( 3, 4, '3 images ! ! !', '<s>3 images</s> ! ! !<u>La version 1.48.1 de NewsDesk</u> a maintenant les possibilit?s pour employer 3 images plus <sub>des sous-titres</sub>.<sup>Yippe</sup> est la vie non grande ?', '<b>MAINTENANT jusqu''? 3 images peuvent ?tre employ?es ! ! !</b>', '', 0, '', '', '' ) , ( 3, 5, '3 beelden!!!', '<s>3 heeft de beelden</s> !!!<u>NewsDesk versie 1.48.1</u> nu het vermogen om 3 beelden plus <sub>ondertitels te gebruiken</sub>.<sup>Yippe</sup> is niet grote het leven?', '<b>NOW tot 3 beelden kan gebruikte!!! zijn</b>', '', 0, '', '', '' ) ;# Affected rows:15

DROP TABLE IF EXISTS newsdesk_reviews;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_reviews(

reviews_id int( 11 ) NOT NULL AUTO_INCREMENT ,

newsdesk_id int( 11 ) NOT NULL default '0',

customers_id int( 11 ) default NULL ,

customers_name varchar( 64 ) NOT NULL default '',

reviews_rating int( 1 ) default NULL ,

date_added datetime default NULL ,

last_modified datetime default NULL ,

reviews_read int( 5 ) NOT NULL default '0',

approved tinyint( 3 ) unsigned default '0',

PRIMARY KEY ( reviews_id )

) TYPE = MYISAM AUTO_INCREMENT =4;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_reviews( reviews_id, newsdesk_id, customers_id, customers_name, reviews_rating, date_added, last_modified, reviews_read, approved )

VALUES ( 1, 1, 2, 'Steve aka 241', 5, '2004-05-12 11:46:51', NULL , 1, 1 ) , ( 2, 3, 2, 'Carsten aka Moyashi', 4, '2003-03-11 01:29:02', NULL , 1, 1 ) , ( 3, 2, 2, 'Carsten aka Moyashi', 5, '2003-03-11 01:29:53', NULL , 0, 0 ) ;# Affected rows:3

DROP TABLE IF EXISTS newsdesk_reviews_description;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_reviews_description(

reviews_id int( 11 ) NOT NULL default '0',

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

reviews_text text NOT NULL ,

PRIMARY KEY ( reviews_id, languages_id )

) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_reviews_description( reviews_id, languages_id, reviews_text )

VALUES ( 1, 1, 'Thanks to Jimmy for his \r\n\r\nefforts in beta testing and providing ideas to help make NewsDesk better' ) , ( 2, 1, 'hehe, after almost a week of effort I was able to finish this part of the mod. I hope that you all enjoy it!' ) , ( 3, 1, 'I wonder who will approve this review just to read it ' ) ;# Affected rows:3

DROP TABLE IF EXISTS newsdesk_to_categories;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE newsdesk_to_categories(

newsdesk_id int( 11 ) NOT NULL default '0',

categories_id int( 11 ) NOT NULL default '0',

PRIMARY KEY ( newsdesk_id, categories_id )

) TYPE = MYISAM ;# MySQL returned an empty result set (i.e. zero rows).

INSERT INTO newsdesk_to_categories( newsdesk_id, categories_id )

VALUES ( 1, 4 ) , ( 2, 2 ) , ( 3, 1 ) ;# Affected rows:3

Here is a confirmation of the SQL query!

Still the same errors!

What do you think it is?

Link to comment
Share on other sites

][v][on$ter

 

I appreciate what you are saying with the above post and it stating that the sql queries were successful however you still need to look at the actual database to verify that the table exists.

 

Then also check that the defines are in the admin/includes/database_tables.php and catalog/includes/database_tables.php

more so in this case this define

define('TABLE_NEWSDESK_CONFIGURATION_GROUP', 'newsdesk_configuration_group');

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

what I see in the News categories box is this

 

Announcements (1)

Practical MIDI (1)

It's there now, sometimes it just the links just dissapear ??

I have been into your site a few times and see no issues with the newsdesk

Steve,

 

It is still happening. It must have something to do with the switching back and

forth of ssl. You are probably not going to see the problem unless you register.

Logged in as a customer, after viewing pages in the site, the new categories contents dissapears. It reappears in the next session.

 

V

Link to comment
Share on other sites

what I see in the News categories box is this

 

Announcements (1)

Practical MIDI (1)

It's there now, sometimes it just the links just dissapear ??

I have been into your site a few times and see no issues with the newsdesk

Steve,

 

It is still happening. It must have something to do with the switching back and

forth of ssl. You are probably not going to see the problem unless you register.

Logged in as a customer, after viewing pages in the site, the new categories contents dissapears. It reappears in the next session.

 

V

have a look at your cookie paths in the configure.php

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

][v][on$ter

 

I appreciate what you are saying with the above post and it stating that the sql queries were successful however you still need to look at the actual database to verify that the table exists.

 

Then also check that the defines are in the admin/includes/database_tables.php and catalog/includes/database_tables.php

more so in this case this define

define('TABLE_NEWSDESK_CONFIGURATION_GROUP', 'newsdesk_configuration_group');

Hi Steve,

 

All the code is has been added as in your install.txt

I dont understand this error im getting!

Thanks!

Edited by 241
Link to comment
Share on other sites

notset4life

 

I have looked at your issue more closely and it is now happening to me whether in https or http, however I do not know what is causing this to affect only the categories box and have been unable to replicate the issue on my sandbox which is a default oscommerce install with the newsdesk added.

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

STEVE

screen.jpg

Just so you can visulize where the error message is coming from.

If i dont hear from you have a good weekend.

Edited by ][v][on$ter
Link to comment
Share on other sites

][v][on$ter

 

Thank you for emailing me your files

 

I will have a proper look at the files that you have sent me.

A brief look at your config files shows wrong paths in the configure.php files also I notice that you have no cookie domain or path defines, which would suggest an early version of osCommerce.

 

All my work was done on osCommerce 2.2MS2

 

I have now loaded your files to a clean install, I had to comment out some of the code that was specific to your install i.e. login box chat and other boxes.

I had to do the same for the admin and correct the wrongly placed code in the index.php

 

I had to correct the paths in the configure.php files.

 

After doing all this the whole thing is up and running with no issues

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

Hi, I incorporated this on my site but I am trying to make it more search engine friendly. How do I get the article title in the Title bar when I am on the newsdesk_info.php pages.

 

For example of what I mean go to

http://www.behealthyfitness.com/healthy-fi...p?newsdesk_id=4

 

I want the title of the page to be "What is Whey Protein?" - I am assuming its very simple through a little php insert in the <title> tags but I can't seem to figure it out. Thanks for your help!!!!

Link to comment
Share on other sites

:o How about my problem?

How about my problem is not offering any information on an issue that resides in your setup that I do not have access to, so have to rely on what information you give, however you do not give information unless poked and proded into giving information.

 

I have asked you a number of questions and you have given answers of yes, this sort of answer gives very little information.

 

I have also told you that your issue is with an earlier version of Newsdesk and whatever fixes you implimented then.

 

I am not a mind reader and if you cannot begin to help yourself then how is it that you can ask of me for help.

I've already delete all the pervious installation of Newsdesk and follow all the install instructions again. Problem is still exist. I've also try to restore the old version, but the problem of new version exist on the old one.

Link to comment
Share on other sites

 

I've already delete all the pervious installation of Newsdesk and follow all the install instructions again.  Problem is still exist.  I've also try to restore the old version, but the problem of new version exist on the old one.

when you restored the old newsdesk did you also restore the database, If you did and are still having issues, what would you deduce from it all.

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

?

I've already delete all the pervious installation of Newsdesk and follow all the install instructions again.? Problem is still exist.? I've also try to restore the old version, but the problem of new version exist on the old one.

when you restored the old newsdesk did you also restore the database, If you did and are still having issues, what would you deduce from it all.

Sure! I did restore the database back to old version.

Link to comment
Share on other sites

?

I've already delete all the pervious installation of Newsdesk and follow all the install instructions again.? Problem is still exist.? I've also try to restore the old version, but the problem of new version exist on the old one.

when you restored the old newsdesk did you also restore the database, If you did and are still having issues, what would you deduce from it all.

Sure! I did restore the database back to old version.

And the newsdesk is not working even though you have the old newsdesk installed and the old newsdesk sql installed.

 

You are having the same issue, what does this tell you

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

I'm using newsdesk and i'm loving it :)

The only thing is when i push read more (lees meer in dutch) the newsdesk_info gets to wide and the left navigation and the right navigation are smaller then on the first page.

 

It's kinda hard to explain for me.. so maybe you can take a look at tweakfreaks and see what i mean.

Link to comment
Share on other sites

I'm using newsdesk and i'm loving it :)

The only thing is when i push read more (lees meer in dutch) the newsdesk_info gets to wide and the left navigation and the right navigation are smaller then on the first page.

 

It's kinda hard to explain for me.. so maybe you can take a look at tweakfreaks and see what i mean.

Glad to hear that at least two people are liking it. :D

 

It looks like it is just the right hand column that is being reduced due to lack of space.

 

I would look at reducing the cellpadding and spacing in catalog/newsdesk_info.php

start here

<!-- left_navigation_eof //-->
</table>
 </td>
<!-- body_text //-->
 <td width="100%" valign="top">

<table border="0" width="100%" cellspacing="3" cellpadding="3">

If this is not enough then move to the next section and reduce that.

 

or increase the overall width of the site by a small amount maybe as little as 2px

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

?

I've already delete all the pervious installation of Newsdesk and follow all the install instructions again.? Problem is still exist.? I've also try to restore the old version, but the problem of new version exist on the old one.

when you restored the old newsdesk did you also restore the database, If you did and are still having issues, what would you deduce from it all.

Sure! I did restore the database back to old version.

And the newsdesk is not working even though you have the old newsdesk installed and the old newsdesk sql installed.

 

You are having the same issue, what does this tell you

It works before the upgarde.

Link to comment
Share on other sites

It works before the upgarde.

If it worked before the upgrade then when upgraded did not then something is missing.

If it was all reverse coded back to the old newsdesk including the sql and is now not working then something is missing.

 

when you are installing the new newsdesk or the old newsdesk are you doing a straight replacement of the files or are you doing a file comparison to see what the changes are.

 

Did you backup your files and database prior to making any changes?

Edited by 241

No longer giving free advice. Please place deposit in meter slot provided.  Individual: [=] SME: [==] Corporation: [===]
If deposit does not fit one of the slots provided then you are asking too much! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Link to comment
Share on other sites

It works before the upgarde.

If it worked before the upgrade then when upgraded did not then something is missing.

If it was all reverse coded back to the old newsdesk including the sql and is now not working then something is missing.

 

when you are installing the new newsdesk or the old newsdesk are you doing a straight replacement of the files or are you doing a file comparison to see what the changes are.

 

Did you backup your files and database prior to making any changes?

I've follow all the instructions and replace all the old files with new file. In additon, backup of files and database is done before the upgrade.

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