[Who's Online Enhancement 1.4]

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(');

[Who's Online Enhancement 1.4]

MySQL said:

 

#1064 - You have an error in your SQL syntax near 'CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `ip_address` ,

ADD `c' at line 1

OK, I tried to run the query in phpmyadmin but I get the above error.

 

Does anyone have a solution for this ?

[Who's Online Enhancement 1.4]

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.

[Who's Online Enhancement 1.4]

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 ?

[[Contribution] Upgrading osC from 2.2 MS2 to 2.2 RC2a]

Thanks Jan

 

Yes, after doing a file comparison I saw the problem and swapped out the mistake.

 

Thanks for taking the time to look at this. :)

[[Contribution] Upgrading osC from 2.2 MS2 to 2.2 RC2a]

Ok I went ahead and made the above change to the compatibility.php file and it has cleared the problem. It remains to be seen if something else is broken, but I will keep my fingers crossed.

 

BTW, thanks for this awesome contribution. It makes life so much easier to be able to follow step by step each step of the upgrade.

[[Contribution] Upgrading osC from 2.2 MS2 to 2.2 RC2a]

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;

 

and

 

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

do_magic_quotes_gpc($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?

 

Thanks

[[Contribution] Upgrading osC from 2.2 MS2 to 2.2 RC2a]

Hi Jan

 

Wow, thanks for the lightning fast reply.

 

The only thing that is on line 179 in compatibility.php is " ?> ", which is right isn't it? :huh:

[[Contribution] Upgrading osC from 2.2 MS2 to 2.2 RC2a]

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

[Links Manager II]

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.

[Links Manager II]

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.

[Links Manager II]

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?

 

Thanks

 

Viper

[Links Manager II]

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

 

Jack

 

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.

 

Viper

[Links Manager II]

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.

[Links Manager II]

hmmmm, ok, thanks Jack, I will try populating one of the undisplayed categories with a test link and see if it works.

[Links Manager II]

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

 

Jack

 

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.

[Links Manager II]

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.

[Links Manager II]

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.

 

Jack

 

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 ?

[Links Manager II]

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`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Jack

 

Hi Jack

 

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

 

MySQL said:

 

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

[Links Manager II]

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.

 

SQL-query:

 

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

[Auspost 3.01 update error]

oops, sorry for this double post.

[Auspost 3.01 update error]

Thanks again, I have a bit of reading to do before I can set the final settings for my store.

 

Andrew

[Auspost 3.01 update error]

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.

 

Andrew

[Auspost 3.01 update error]

Hi Coopco

 

Ok, I think you were right the first time, I will reupload the files again and double check each one before hitting the upload button. I will post back here to let you know how I go.

 

Thanks again.

 

Andrew

[Auspost 3.01 update error]

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.

 

Andrew