Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Who's Online Enhancement 1.4


Guest

Recommended Posts

Well, I spoke too soon. As soon as the page refreshed, I got the dreaded error below.

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/popthet/public_html/catalog/admin/includes/functions/database.php on line 45
0 -

 

It seems to only be giving this error when it refreshes and tries to display the circle icon.

 

My site is still new and I am not getting a lot of visitors yet so it is hard for me to really test it. When I login as guest or login through one of my accounts, everything works fine. It screws up with everyone else who visits the site.

Edited by PopTheTop

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Hi there,

 

I have downloaded the 1.6 version and everything is fine.

 

How can I have "Currently there are 25 customers online" in the bottom of the custumer page, near the "565 requests since Tuesday 08 March, 2005 ".

 

Please help.

 

Best regards,

Marc

Edited by thedream

osCommerce 2.2 MS2 in 6 languages

TVA Intracomm

Numbers of visitors online

Who's online Enhancement

....

Link to comment
Share on other sites

Man! The errors keep rolling in and they really SUCK!

 

So that you all can see them, here they are. As far as the language file errors, as you can see, there is no such thing as a file called yyyybox.php and some times it is left blank or the language file name is USA.php. Where is this getting that????

 

 

WOL_error-2.jpg

 

 

This is the icon display error.

 

 

WOL_error-1.jpg

 

 

It seems to only happen at various times. Not every time. The icon display error happens when the page loads. The language error happens when I click on any line to highlight / select that line.

 

Is this what is happening to others here????

 

I have the sessions setup as:

Session Directory - /home/popthet/public_html/catalog/sessions

Force Cookie Use - False

Check SSL Session ID - True

Check User Agent - False

Check IP Address - False

Prevent Spider Sessions - True

Recreate Session - True

 

 

In catalog/includes/config.php

define('HTTP_MAIN_HOME', 'http://www.popthetop.com');

define('HTTP_SERVER', 'http://www.popthetop.com');

define('HTTPS_SERVER', 'https://www.popthetop.com');

define('ENABLE_SSL', true);

define('HTTP_COOKIE_DOMAIN', 'www.popthetop.com');

define('HTTPS_COOKIE_DOMAIN', 'www.popthetop.com');

define('HTTP_COOKIE_PATH', '/catalog/');

define('HTTPS_COOKIE_PATH', '/catalog/');

define('DIR_WS_HTTP_CATALOG', '/catalog/');

define('DIR_WS_HTTPS_CATALOG', '/catalog/');

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', '/home/popthet/public_html/catalog/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

 

In catalog/admin/includes/config.php

define('HTTP_SERVER', 'http://www.popthetop.com/catalog');

define('HTTPS_SERVER', 'https://www.popthetop.com/catalog');

define('HTTP_CATALOG_SERVER', 'http://www.popthetop.com');

define('HTTPS_CATALOG_SERVER', 'https://www.popthetop.com');

define('ENABLE_SSL_CATALOG', 'true');

define('DIR_FS_DOCUMENT_ROOT', '/home/popthet/public_html/');

define('DIR_WS_ADMIN', '/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

define('DIR_WS_CATALOG', '/catalog/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

define('DIR_WS_IMAGES', 'images/');

define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');

define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');

define('DIR_WS_INCLUDES', 'includes/');

define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');

define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');

define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');

define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');

define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');

define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');

define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');

define('DIR_FS_BACKUP', '/home/popthet/public_html/catalog/admin/backups/');

 

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

 

Any clues here???

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Scott

 

There does not seem a whole lot I can suggest but 2 things you could look at.

 

1. Have you tried changing "Check SSL Session ID - False" ?

2. Also where are you storing your cache files?

For example I have my set to "/home/myusername/public_html/shop/cache/"

it's highly possible this maybe getting confused with som other cart on a shared server.

 

Also I note the "include.:/usr/lib/php:/usr/local/lib/php" line. I have to wonder if this file is not corrupt or something wrong with it. You might want to get on to you host provider to have them look at this.

 

John

Link to comment
Share on other sites

1) Made the change to Check SSL Session ID - False

I will let you know if it does anything

 

2) What cache files? Are you talking about Box Cache? If so, that is turned off so that my DHTML menus will run. But when I have them turned on, it is set to /home/popthet/public_html/catalog/cache/

 

3) include.:/usr/lib/php:/usr/local/lib/php??? Where do you see that?

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Here's what I've learned from the test feedback:

 

Install:

2) A function that needs to be added to admin/includes/functions/general.php was missing.

 

Fix:

1) A fix for some people who couldn't see Last URL was identified.

 

What is the fix for people who cannot see the Last URL and the missing function that are mentioned here?

Link to comment
Share on other sites

Great contribution BTW. A much better version than the rest. :thumbsup:

I have installed the latest BETA version and it all appears to be working fine, except i cannot see what customers have in their cart. This however, happened with all the other versions, so it's not just the BETA version. Anybody got any ideas how to resolve this. The shopping cart column is there but shows nothing in it.

 

TIA

 

Julian

A little knowledge is dangerous, I SHOULD KNOW.

If Life Begins At 40, What ends????

Link to comment
Share on other sites

julian,

 

I had the same problem until I did this..

 

"The STORE_SESSIONS value in catalog/includes/configure.php and admin/includes/configure.php MUST be the same."

 

I set both of them to mysql and now the cart works great.

 

I hope it helps.

Link to comment
Share on other sites

Well, changed one more thing and now everything seems to be running fine. I hope it stays this way because I really do not want to un-install this great MOD.

 

Updated changes to my Admin / Config / Sessions settings:

 

Session Directory - /sessions

Force Cookie Use - False

Check SSL Session ID - False

Check User Agent - False

Check IP Address - False

Prevent Spider Sessions - True

Recreate Session - False -------- Changed this to FALSE

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

julian,

 

I had the same problem until I did this..

 

"The STORE_SESSIONS value in catalog/includes/configure.php and admin/includes/configure.php MUST be the same."

 

I set both of them to mysql and now the cart works great.

 

I hope it helps.

Thanks for the reply Jeff. I've just had a look and mine are both set to mysql :'(

Any more ideas appreciated?? Cheers

 

Julian

 

ps: I suppose it must be some sort of config setting though, as it's done it with every version.

Edited by julianpuje

A little knowledge is dangerous, I SHOULD KNOW.

If Life Begins At 40, What ends????

Link to comment
Share on other sites

What is the fix for people who cannot see the Last URL and the missing function that are mentioned here?

Dom,

 

Check out the second post on page 12 of this thread. I post the functions and instructions there.

 

ed

Link to comment
Share on other sites

UPDATE...

 

It just seemed that all my problems were coming from the status icon column.

 

I went in and deleted ALL the code that this column uses and deleted the column itself all together.

 

So far so good... no errors at all. I will be keeping my fingers crossed for this one. If that did the trick then I will leave this installed. If not, a tear-out will be in order.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

One question...

The Profile Display never did anything. What is it supposed to do?

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Scott,

 

Does that mean you won't have the lights? I'm trying to work on it. I've only seen it happen on my site once.

 

The Profile Display is supposed to show extra lines of information, like osCsid, User Agent, etc. under each entry. One of the screen shots in the contrib shows what it does.

 

ed

Link to comment
Share on other sites

Correct, I no longer have the status lights. So far, no problems. I could care less about them anyway.

 

As far at the Profile Display goes, noting happens when I choose any of them to be displayed. The page just reloads.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Hi All,

 

I did try every solution that posted here but I'm sitll getting warning: :angry:

  
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/hepsib/public_html/adminht/includes/functions/database.php on line 45
0 -

select session_id, time_entry, time_last_click from whos_online where session_id='1de5a85be2c5463b8de375a10a9c7b98'

[TEP STOP]

 

Just a few click to refresh page then I get another strange error in my browser:

Warning: main(includes/languages/4): failed to open stream: No such file or directory in /home/hepsib/public_html/adminht/includes/application_top.php on line 133

Fatal error: main(): Failed opening required 'includes/languages/4' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hepsib/public_html/adminht/includes/application_top.php on line 133

 

With my language files everything seem normal. Then I went to my admin area using Firefox browser, it shows admin screens normally, but IE still shows above error screen. Just a few hours later IE starts to show everthing perfect.

 

No idea why this happens! :huh:

Link to comment
Share on other sites

Get rid of those lights and your problems will be solved.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

I've just installed the Who's Online Enhancement v1.6.1Beta in my test environment. Copied the files, ran the SQL code and changed the general.php file. However, when I go to Who's Online in admin it gives me the following error:

 

1054 - Unknown column 'http_referer' in 'field list'

select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, http_referer, session_id from whos_online order by time_last_click DESC

[TEP STOP]

 

I have checked this thread for simular problems, but couldn't find any. Does anybody know how to tackle this problem?

 

Thanks,

RojanUK

Link to comment
Share on other sites

Roger,

 

I know you said you ran the SQL statement, but check the database and make sure http_referer is really there.

 

ed

I double-checked as per your suggestion and you were quite right. I did run it, but on the wrong db. When I ran it on the correct one, problem was solved. :thumbsup:

 

Thanks!

RojanUK

Link to comment
Share on other sites

HA HA HA! Don't you just HATE that when it happens! I have done that one myself ;)

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Well, just for an update...

 

It's been a while since I deleted all the code for the after I deleted all the code for the lights (small images on the far left column). I have not had one problem at all. Everything is working GREAT except for the fact that the Profile Display does not work.

 

I love this contribution, but the lights need to be updated so that they are not buggy.

L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Link to comment
Share on other sites

Scott,

 

I'm working on that. I've tweaked some code in the whos_online.php on the catalog side and I'm testing it out on my site. If that goes well, I'll post a 1.6.2 Beta or something like that, incorporating other fixes also posted. Probably won't be for a week or 2.

 

As far as I can tell, you are the only user with profile problems. I have changed that a little. Much earlier in this thread, BoulderDash suggested storing the user_agent in a new column in the whos_online table. I've adopted that as well.

 

ed

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