olsonsp4c Posted December 19, 2008 Author Share Posted December 19, 2008 Great contribution. Thanks a lot for doing this. When I log into my admin panel in the News window I get a message saying: ERROR: I can connect to MYSQL but can not check the tables. My database is local and I created the user will all rights except grant. Any suggestions how to fix this, do I need to worry about it? Thanks angain. D. Unfortunately, I'm not really adept at mysql... Have you verified that your info in the config file is identical to that in your includes/configure.php file? Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
inliquid Posted December 22, 2008 Share Posted December 22, 2008 I am having a problem with the customer support window popping up. When I turn off the STS template it works but when it is on the support window does not pop up. Everything on the admin side seems to be working fine. Any ideas? Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted December 22, 2008 Author Share Posted December 22, 2008 did STS have you install a javascript function for popups with the same function name? Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
inliquid Posted December 23, 2008 Share Posted December 23, 2008 Hi Scott, I don't believe that STS has the same function name on a pop up window. I did try changing it just to be sure and the window still does not pop up. Chris Quote Link to comment Share on other sites More sharing options...
inliquid Posted December 23, 2008 Share Posted December 23, 2008 Scott thanks for getting back to me. I resolved my problem by moving the javascript function to an external file. Now everything is working. Best Chris Quote Link to comment Share on other sites More sharing options...
formula1 Posted December 30, 2008 Share Posted December 30, 2008 I have it all set up and in its most it appears to be working. I am having one major problem though I can not get the window to pop up (user). I am currently using STS and I am assuming this is where the problems are lying and something to do with the javascript commands. I noticed this has been mentioned already, only inliquid never went into detail on how he fixed it... Is there any work around for this, (I am not the best at scripting and can not find a solution on my own) many thanks in advance. Gary Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted December 30, 2008 Author Share Posted December 30, 2008 I have it all set up and in its most it appears to be working. I am having one major problem though I can not get the window to pop up (user). I am currently using STS and I am assuming this is where the problems are lying and something to do with the javascript commands. I noticed this has been mentioned already, only inliquid never went into detail on how he fixed it... Is there any work around for this, (I am not the best at scripting and can not find a solution on my own) many thanks in advance. Gary Gary, I don't know personally how to fix it; however, I would suggest that you message Chris above and ask him what he did. I'm sure he'd be willing to post his solution or message it to you. Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Nathali Posted January 7, 2009 Share Posted January 7, 2009 Hi Scott, I think I got into troubles.. I forgot my admin. user name & password !! Is there a way to correct it? Waiting please for any advise from you.. Thanks again dear Scott, Regards, Nath Quote Best Regards, Nathali Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 7, 2009 Author Share Posted January 7, 2009 Hi Scott, I think I got into troubles.. I forgot my admin. user name & password !! Is there a way to correct it? Waiting please for any advise from you.. Thanks again dear Scott, Regards, Nath you can look it up in the store database in the "bvars" table... Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Nathali Posted January 7, 2009 Share Posted January 7, 2009 you can look it up in the store database in the "bvars" table... Scott Hi Scott ! How are you? I looked in the database in the "bvars" table, and I see there only this: bname bvalue conf_GEmailSubject Message from online support conf_Msg1 Please Wait... conf_Msg2 Locating an Available and Online Customer Service ... I think it's not there.. Is there another place I could look for? Thanks Scott, Happy New Year, Nath Quote Best Regards, Nathali Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 7, 2009 Author Share Posted January 7, 2009 Hi Scott ! How are you? I looked in the database in the "bvars" table, and I see there only this: bname bvalue conf_GEmailSubject Message from online support conf_Msg1 Please Wait... conf_Msg2 Locating an Available and Online Customer Service ... I think it's not there.. Is there another place I could look for? Thanks Scott, Happy New Year, Nath happy ny to you as well! here's what i found on the phponline forum: If you forgotten your admin login and/ or password, You need to reset everything to factory default. To do that drop all MySQL tables and let them to be created again. Then you may login with admin as username and adm123 as password. Thanks! Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Nathali Posted January 7, 2009 Share Posted January 7, 2009 happy ny to you as well! here's what i found on the phponline forum: If you forgotten your admin login and/ or password, You need to reset everything to factory default. To do that drop all MySQL tables and let them to be created again. Then you may login with admin as username and adm123 as password. Thanks! Scott Thanks a lot Scott ! So which MySQL tables I should delete? "bvars" & "msgdb" & "cs" ? Thanks, Nath Quote Best Regards, Nathali Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 7, 2009 Author Share Posted January 7, 2009 Thanks a lot Scott ! So which MySQL tables I should delete? "bvars" & "msgdb" & "cs" ? Thanks, Nath yes :D Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Nathali Posted January 7, 2009 Share Posted January 7, 2009 yes :D Great !! What could I do without you ! :D Nath Quote Best Regards, Nathali Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2009 Share Posted January 12, 2009 Just to report that I installed this contrib with no problems, except the image did not appear in the Live Support box. Whe I changed the $phponline_status_indicator_type indicator in \includes\boxes\live_support.php to 1, it worked as it should. Quote Link to comment Share on other sites More sharing options...
dspeak Posted January 16, 2009 Share Posted January 16, 2009 I have installed this, installed the database, made the changes in the config file, but all I get in admin side is a blank. On user side I get the dayana window, but nothing happens. I followed the installation to a "T". I have even uninstalled it, uninstalled the database 6 times and I always get the same results. Please help Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 16, 2009 Author Share Posted January 16, 2009 I have installed this, installed the database, made the changes in the config file, but all I get in admin side is a blank. On user side I get the dayana window, but nothing happens. I followed the installation to a "T". I have even uninstalled it, uninstalled the database 6 times and I always get the same results. Please help it would be impossible for me to suggest something without looking at it, having ftp access to your website, and to your osC admin. Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Stroker396 Posted January 25, 2009 Share Posted January 25, 2009 Ok, I also followed the directions and have been over every part of them and I have the problem of the blank screen. I cannot even get to the admin it is just completely blank. Now I am curious though I did not see and .sql files there was nothing to upload to the database? Am I missing something here. I have been looking on the daymb forums for answers as well, not much luck so far. Quote The Site can be viewed at www.performanceautopartsonline.com The site is live (despite these minor glitches) please respect that and do not sign up etc... maybe a contribution one day when I get this site the way I want it. I don't make spelling mistakes! I have dyslecsic fingers. Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 25, 2009 Author Share Posted January 25, 2009 Ok, I also followed the directions and have been over every part of them and I have the problem of the blank screen. I cannot even get to the admin it is just completely blank. Now I am curious though I did not see and .sql files there was nothing to upload to the database? Am I missing something here. I have been looking on the daymb forums for answers as well, not much luck so far. I don't understand what you mean by blank screen. please post screenshots. The sql is automatically added. there is no sql to upload. Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Stroker396 Posted January 25, 2009 Share Posted January 25, 2009 1. When I meant blank screen I meant nothing but white, plain, nada, nothing. 2. I figured out the problem, it was no thanks to Godaddy, they are going to be switching the database server and gave me the info for the new one but it is not transfered yet, so 1 call and I got the current info and BAM! it works. Sorry to waste your time. But when I made changes then I would get the errors but with localhost (which it is not) it gave the blank screen. Hopw that help someone else, check with your host company to get the correct info as 'localhost' is not correct in all instances. Quote The Site can be viewed at www.performanceautopartsonline.com The site is live (despite these minor glitches) please respect that and do not sign up etc... maybe a contribution one day when I get this site the way I want it. I don't make spelling mistakes! I have dyslecsic fingers. Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 28, 2009 Author Share Posted January 28, 2009 Glad you got it working Mark. Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Stroker396 Posted January 28, 2009 Share Posted January 28, 2009 I must say I love this contribution! Excellent work. Now having said that, I have a couple of questions/requests that I think can make it even better. 1. If on the ring tones selector in the admin if there was a way to press play to preveiw each one before selecting it (other wise I have to test it from the user side each time, or from my computer (good for the staff as well). 2. Is there a way to set the window size of the popup on the users end so that it is just slightly larger than the border (like the admin is) currently mine comes up short of a full page with lots of wasted white space. 3. Is there a way to make the admin window turn orange in the bottom (start menu) when the window is minimized when there is someone waiting (many other programs do this for various reasons i.e. yahoo IM) I would start looking into it but I am not a programmer and I have so many other things on my plate, but I thought I would throw it out there. Thanks again, Quote The Site can be viewed at www.performanceautopartsonline.com The site is live (despite these minor glitches) please respect that and do not sign up etc... maybe a contribution one day when I get this site the way I want it. I don't make spelling mistakes! I have dyslecsic fingers. Link to comment Share on other sites More sharing options...
olsonsp4c Posted January 28, 2009 Author Share Posted January 28, 2009 I must say I love this contribution! Excellent work. Now having said that, I have a couple of questions/requests that I think can make it even better. 1. If on the ring tones selector in the admin if there was a way to press play to preveiw each one before selecting it (other wise I have to test it from the user side each time, or from my computer (good for the staff as well). 2. Is there a way to set the window size of the popup on the users end so that it is just slightly larger than the border (like the admin is) currently mine comes up short of a full page with lots of wasted white space. 3. Is there a way to make the admin window turn orange in the bottom (start menu) when the window is minimized when there is someone waiting (many other programs do this for various reasons i.e. yahoo IM) I would start looking into it but I am not a programmer and I have so many other things on my plate, but I thought I would throw it out there. Thanks again, Thanks... 2 of those suggestion could just go directly to dynahost that wrote the actual software at http://www.dayanahost.com/forum2/index.php...SF&f=8& (I just ported it to osCommerce and customized it a bit) The popup in the catalog and admin can be changed in size. Just look at the javascript in the infobox file and in the admin/includes/header.php and look for the height width settings which are large numbers like 500, 450 or something like that... Scott Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
Stroker396 Posted February 1, 2009 Share Posted February 1, 2009 Ok this is strange. On the admin side the screen sizes fine. But on the client side like I said the screen comes up almost as a full page and yet I looked up the settings and they are set at 5xx and 400 already, but for some reason it is not following that? wonder if there is an error in the script? THis is the script in includes/boxes/live_support.php (I enlarged the sizes a bit as a test) <script language="javascript"><!-- function phpOnlinePopupWindow() { var url = "<?php echo $phpOnline_base_url.'/client.php';?>"; window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=no,copyhistory=no,width=650,height=450,screenX=150,screenY=150,top=150,lef t=150') } //--></script> Quote The Site can be viewed at www.performanceautopartsonline.com The site is live (despite these minor glitches) please respect that and do not sign up etc... maybe a contribution one day when I get this site the way I want it. I don't make spelling mistakes! I have dyslecsic fingers. Link to comment Share on other sites More sharing options...
olsonsp4c Posted February 1, 2009 Author Share Posted February 1, 2009 (edited) Ok this is strange. On the admin side the screen sizes fine. But on the client side like I said the screen comes up almost as a full page and yet I looked up the settings and they are set at 5xx and 400 already, but for some reason it is not following that? wonder if there is an error in the script? THis is the script in includes/boxes/live_support.php (I enlarged the sizes a bit as a test) <script language="javascript"></script> In should read like this with no line break after "res" or after "lef": <script language="javascript"><!-- function phpOnlinePopupWindow() { var url = "<?php echo $phpOnline_base_url.'/client.php';?>"; window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=no,copyhistory=no,width=650,height=450,screenX=150,screenY=150,top=1 50,le f t=150') } //--></script> in this example you gave, the width is 650 and height 450 you might check your index.php to see if there is another popup script with the same name "popupWindow" - if so, rename that part. Scott Edited February 1, 2009 by olsonsp4c Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox 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.