PopTheTop Posted March 28, 2005 Share Posted March 28, 2005 (edited) 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 March 28, 2005 by PopTheTop Quote 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 More sharing options...
thedream Posted March 28, 2005 Share Posted March 28, 2005 (edited) 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 March 28, 2005 by thedream Quote osCommerce 2.2 MS2 in 6 languages TVA Intracomm Numbers of visitors online Who's online Enhancement .... Link to comment Share on other sites More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 Marc, You could try this contrib. Quote Link to comment Share on other sites More sharing options...
thedream Posted March 28, 2005 Share Posted March 28, 2005 thank you ! you're great. Quote osCommerce 2.2 MS2 in 6 languages TVA Intracomm Numbers of visitors online Who's online Enhancement .... Link to comment Share on other sites More sharing options...
PopTheTop Posted March 28, 2005 Share Posted March 28, 2005 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???? This is the icon display error. 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??? Quote 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 More sharing options...
Guest Posted March 28, 2005 Share Posted March 28, 2005 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 Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted March 29, 2005 Share Posted March 29, 2005 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? Quote 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 More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 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. <{POST_SNAPBACK}> What is the fix for people who cannot see the Last URL and the missing function that are mentioned here? Quote Link to comment Share on other sites More sharing options...
julianpuje Posted March 29, 2005 Share Posted March 29, 2005 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 Quote A little knowledge is dangerous, I SHOULD KNOW. If Life Begins At 40, What ends???? Link to comment Share on other sites More sharing options...
jrdaniels0 Posted March 29, 2005 Share Posted March 29, 2005 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. Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted March 29, 2005 Share Posted March 29, 2005 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 Quote 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 More sharing options...
julianpuje Posted March 29, 2005 Share Posted March 29, 2005 (edited) 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. <{POST_SNAPBACK}> 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 March 29, 2005 by julianpuje Quote A little knowledge is dangerous, I SHOULD KNOW. If Life Begins At 40, What ends???? Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2005 Share Posted March 29, 2005 What is the fix for people who cannot see the Last URL and the missing function that are mentioned here? <{POST_SNAPBACK}> Dom, Check out the second post on page 12 of this thread. I post the functions and instructions there. ed Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted March 30, 2005 Share Posted March 30, 2005 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. Quote 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 More sharing options...
PopTheTop Posted March 30, 2005 Share Posted March 30, 2005 One question... The Profile Display never did anything. What is it supposed to do? Quote 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 More sharing options...
Guest Posted March 30, 2005 Share Posted March 30, 2005 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 Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted March 30, 2005 Share Posted March 30, 2005 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. Quote 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 More sharing options...
expert Posted April 4, 2005 Share Posted April 4, 2005 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: Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted April 4, 2005 Share Posted April 4, 2005 Get rid of those lights and your problems will be solved. Quote 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 More sharing options...
RojanUK Posted April 7, 2005 Share Posted April 7, 2005 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, Quote RojanUK Link to comment Share on other sites More sharing options...
Guest Posted April 7, 2005 Share Posted April 7, 2005 Roger, I know you said you ran the SQL statement, but check the database and make sure http_referer is really there. ed Quote Link to comment Share on other sites More sharing options...
RojanUK Posted April 7, 2005 Share Posted April 7, 2005 Roger, I know you said you ran the SQL statement, but check the database and make sure http_referer is really there. ed <{POST_SNAPBACK}> 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! Quote RojanUK Link to comment Share on other sites More sharing options...
PopTheTop Posted April 7, 2005 Share Posted April 7, 2005 HA HA HA! Don't you just HATE that when it happens! I have done that one myself ;) Quote 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 More sharing options...
PopTheTop Posted April 7, 2005 Share Posted April 7, 2005 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. Quote 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 More sharing options...
Guest Posted April 7, 2005 Share Posted April 7, 2005 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.