Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by Viper0409

  1. I copied this code below from the install(or Update).txt file. and pasted into phpmyadmin query box and hit go.


    ALTER TABLE `whos_online` ADD `country_code` VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `ip_address` ,
    ADD `country_name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `country_code` ,
    ADD `region_name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `country_name` ,
    ADD `city` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `region_name` ,
    ADD `latitude` FLOAT NOT NULL AFTER `city` ,
    ADD `longitude` FLOAT NOT NULL AFTER `latitude`;
    ALTER TABLE `whos_online` ADD INDEX `ip_address` ( `ip_address` );
    ALTER TABLE `whos_online` ADD INDEX `country_code` ( `country_code` );
    ALTER TABLE whos_online ADD http_referer VARCHAR(255) NOT NULL;
    ALTER TABLE whos_online ADD user_agent VARCHAR(255) NOT NULL;
    ALTER TABLE `whos_online` ADD `hostname` VARCHAR( 255 ) NOT NULL AFTER `ip_address` ;
    REPAIR TABLE `whos_online`;
    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 ('77', 'Google Maps Key', 'GOOGLE_MAPS_KEY', 'YOURKEY', 'Put your Google Maps API Key here.<br><br>You can get one at http://code.google.com/apis/maps/signup.html', '1', '25', NULL, '2009-08-22 12:18:00', NULL, 'tep_cfg_textarea(');

  2. I have just reuploaded a new zip to the contribution. It will take some time to show up because of:


    "As the filesize is over 300k, it will be manually approved before becoming publicly available."


    Thanks for re-uploading this. I successfully extracted it and will install shortly.

  3. Hi


    I just downloaded version 3.6.6 and couldn't extract it. I have repeated this 3 times with the same result. I did read back through this thread and noticed that someone had asked for version 3.6.6 to be re-uploaded but did not see a response to that post.


    Has anyone else had this experience ?

  4. ok I just compared the two files, one from the package and my local file, and this is the only difference.


    if (!is_array($ar)) return false;




    if (is_array($ar[$key])) {



    The first quote is the package file and the second is my file. Should I make it same as the package file or would there be a reason for the difference?



  5. Hi


    I am in the process of updating my osCommerce 2.2 MS2 to rc2a and I am manually editing each file because I have quite a few contributions in my store.


    I have run into a problem as shown below.


    Parse error: parse error in /catalog/includes/functions/compatibility.php on line 179


    Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /catalog/includes/functions/compatibility.php:179) in /catalog/includes/functions/sessions.php on line 99


    Can anyone offer any advice on how to overcome this.


    Thanks in advance

  6. For the benefit of anyone else who may come across this error/warning at some stage.


    I finally found the cause of the error/warning in the above posts. The lines 132 to 139 were contained in the Blacklisted words function in catalog/links_submit.php file shown below.


    This was the error/warning:

    Warning: strpos(): Empty delimiter. in /catalog/links_submit.php on line 132


    This is the function:

    //CHECK FOR BLACKLISTED WORDS AS DEFINED IN admin->configuration->Links

    if ( tep_not_null(LINKS_CHECK_BLACKLIST))


    $parts = explode(",", LINKS_CHECK_BLACKLIST);


    for ($i = 0; $i < count($parts); ++$i)


    if ((strpos($links_title, $parts[$i]) !== FALSE) ||

    (strpos($links_url, $parts[$i]) !== FALSE) ||

    (strpos($links_category, $parts[$i]) !== FALSE) ||

    (strpos($links_category_suggest, $parts[$i]) !== FALSE) ||

    (strpos($links_description, $parts[$i]) !== FALSE) ||

    (strpos($links_image, $parts[$i]) !== FALSE) ||

    (strpos($links_contact_name, $parts[$i]) !== FALSE) ||

    (strpos($links_contact_email, $parts[$i]) !== FALSE))


    $error = true;

    $messageStack->add('submit_link', ENTRY_LINKS_BLACKLISTED);





    I had list of words that I had inserted into my blacklisted words in admin/links and decided to remove a phrase but had left a comma at the end of the last word. This was the empty delimiter that was referred to in the error/warning. eg. bad word a, bad word b, bad word c, <--- notice the comma at the end of the line.


    After I removed the comma, it worked perfectly and the warning disappeared.

  7. Thanks for your reply Jack


    I do have the latest version of this contribution V1.22, but I pasted the wrong lines into my post above, from another file, apologies for the incorrect information.


    the correct lines in catalog/links_submit.php are:


    if ((strpos($links_title, $parts[$i]) !== FALSE) ||

    (strpos($links_url, $parts[$i]) !== FALSE) ||

    (strpos($links_category, $parts[$i]) !== FALSE) ||

    (strpos($links_category_suggest, $parts[$i]) !== FALSE) ||

    (strpos($links_description, $parts[$i]) !== FALSE) ||

    (strpos($links_image, $parts[$i]) !== FALSE) ||

    (strpos($links_contact_name, $parts[$i]) !== FALSE) ||

    (strpos($links_contact_email, $parts[$i]) !== FALSE))

    The warning error is still on lines 132 through to 139.


    Thanks for any help you can provide Jack.

  8. Hi Jack


    I am back again.


    I was just testing adding a link from the store front and ran into this error after filling in all the details and submitting the test link.


    Warning: strpos(): Empty delimiter. in /catalog/links_submit.php on line 132


    In fact the same error occurs for line 132 through to line 139. i.e. The error repeats for line 133, 134, etc.


    Here are the lines 132 to 139 in my catalog/links_submit.php file.


    $links_id = tep_db_insert_id();


    $categories_query = tep_db_query("select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $links_category . "' and language_id = '" . (int)$languages_id . "'");


    $categories = tep_db_fetch_array($categories_query);

    $link_categories_id = $categories['link_categories_id'];


    tep_db_query("insert into " . TABLE_LINKS_TO_LINK_CATEGORIES . " (links_id, link_categories_id) values ('" . (int)$links_id . "', '" . (int)$link_categories_id . "')");


    Would you have an idea about what is causing this warning/ error?





  9. I looked at the code and it will only show categories with links. If you want to change that, find this code, around line 208, and remove it.
    if ($linkCount > 0) //only show categories with links




    Hi Jack and thanks for your reply, apologies for getting back to you so late, I had a few things to take care of.


    The above code mod has resolved the problem with the non-populated categories not displaying. All 6 categories are now displayed.


    Thanks once again for your help and for all the work you do in this and other forums.



  10. Ok, I am back again.


    According to my site, when the categories are not populated, the categories are hidden. As soon as I populated a non-displayed category, the category appeared.


    Just letting you know how it is working on my site.


    Let me know if this is not the correct functionality.

  11. Try editingt the links.php file and change all instances of xor to or.




    Thank you very much Jack, it works perfectly now.


    Another quick question if I may. If there are empty categories, are they Hidden ? In my shop I have 6 categories, but only three populated ones are displayed, the other 3 unpopulated ones are not displaying.

  12. Hi Jack


    I have run the all the updates in the updates folder for the db and all is fine as far as that is concerned. Everything in the admin for Links Manager and configuration all seem to be fine. However when I click each of the Link Categories at the shops front end, I get the following error.


    1064 - You have an error in your SQL syntax near 'xor ld.language_id = '99')' at line 1


    select count(l.links_id) as total from links_description ld left join links l on ld.links_id = l.links_id left join links_to_link_categories l2lc on l.links_id = l2lc.links_id where l.links_status = '2' and CHAR_LENGTH(ld.links_title) > '0'and l2lc.link_categories_id = '4' and ( ld.language_id = '1' xor ld.language_id = '99')


    [TEP STOP]


    Any ideas as to what the problem is ? Once again thanks in advance and I appreciate your help.

  13. Try this
    DROP TABLE IF EXISTS links_exchange;
      CREATE TABLE `links_exchange` (
    	`links_exchange_name` varchar(255) NOT NULL default '',
    	`links_exchange_description` text,
    	`links_exchange_url` varchar(255) default NULL,
    	`language_id` int(11) NOT NULL default '0',
    	PRIMARY KEY  (`language_id`)
      ) TYPE=MyISAM;

    Links_setup won't run if you have an existing installation.




    Thanks Jack for you quick reply.


    That solved the problem, I will move on to the next update now. Just another question if you have time, I can only see update from 1.19 to 1.20 in the update docs package, is there no update to the current release of 1.22 ?

  14. Try this
    DROP TABLE IF EXISTS links_exchange;
     CREATE TABLE `links_exchange` (
       `links_exchange_name` varchar(255) NOT NULL default '',
       `links_exchange_description` text,
       `links_exchange_url` varchar(255) default NULL,
       `language_id` int(11) NOT NULL default '0',
       PRIMARY KEY  (`language_id`)




    Hi Jack


    Thanks for your reply. I tried that sql query and this is the error that is returned.


    MySQL said: b_help.png


    #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 7


    Do you have any ideas why this is happening ? If I am updating the update sql's in order, do I have to still run the links_setup.php ? I have uploaded all the new files to the server into their respective folders btw.


    Thanks again for any help you can offer.

  15. Hi Jack


    I have been trying to update links Manager from 1.14 to 1.22 and was running the sql updates. I successfully updated 1.14 to 1.16 and then tried updating 1.16 to 1.19 but I am getting a MySql error.




    CREATE TABLE links_exchange(

    links_exchange_name varchar( 255 ) NULL ,

    links_exchange_description text NULL ,

    links_exchange_url varchar( 255 ) NULL ,

    PRIMARY KEY ( links_exchange_name )



    MySQL said: Documentation

    #1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead


    I read back to about page 24 to see if anyone else had come across this, but couldn't find anything.


    Any ideas as to what might be causing this or is there problem with the sql update for 1.16 to 1.19 query?


    Thanks in advance

  16. Thanks Coopco


    for pointing me in the right direction the first time and apologies, I was sure I got it right but in fact I did upload the wrong files to catalog/includes/languages/english/modules/shipping. It is working ok now, but I need to set it up with my previous settings. .


    Are the default values for the insurance etc the correct ones ? if not do you have a link to where I can get the correct settings.


    Thanks again, much appreciated.



  17. Hi Coopco


    Thanks for your quick response. I am sure that I have uploaded the catalog/includes/modules/shipping files and the catalog/includes/languages/english/modules/shipping files to their correct locations. My next step was to uninstall and reinstall the shipping modules in admin but this error came up before I got that far.


    I would appreciate any further assistance if you have other suggestions. I am stuck at the moment, I just don't understand what the error is pointing to.


    Thanks again.