musenut Posted November 10, 2006 Share Posted November 10, 2006 How can I get my database to show up in phpMyAdmin? I am trying to run the SPCC database update and have made all the mods to the .php files. But I have yet to figure out how to run the spcc_v41_install.sql database installation file thanks :blink: kristy Link to comment Share on other sites More sharing options...
kgt Posted November 10, 2006 Share Posted November 10, 2006 How can I get my database to show up in phpMyAdmin? I am trying to run the SPCC database update and have made all the mods to the .php files. But I have yet to figure out how to run the spcc_v41_install.sql database installation file thanks :blink: kristy Did you install this phpMyAdmin yourself? Your host should have one available via your control panel. If that's the one you're using, you need to get in touch with your host to solve the issue. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
musenut Posted November 10, 2006 Author Share Posted November 10, 2006 Did you install this phpMyAdmin yourself? Your host should have one available via your control panel. If that's the one you're using, you need to get in touch with your host to solve the issue. they did not have one - I had to install it myself ... what do I do? Link to comment Share on other sites More sharing options...
kgt Posted November 10, 2006 Share Posted November 10, 2006 You need to tell it how to connect to your database. Edit config.inc.php: $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection // (requires PHP >= 4.3.0) $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" // and "mysql/db" tables). // The controluser is also // used for all relational // features (pmadb) $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = ''; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed Change host, user, and password to the values in your OSC includes/configure.php. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
Gameprodigy Posted November 10, 2006 Share Posted November 10, 2006 check your installation, after installing it you may have to import the database your using for you store. It probably won't automatically detect your database, im sure you have to install or import it into your phpmyadmin. I read some documentation from this site: http://my.ezpublishing.com/kb/search.php?q...ase+not+showing It says you have to create the database, then go to manage my database. This article may help you. Link to comment Share on other sites More sharing options...
musenut Posted November 10, 2006 Author Share Posted November 10, 2006 THANK YOU!!! I have been knashing my teeth for several days over this. What you gave me seems to have worked altho I got this error: #1060 - Duplicate column name 'customers_group_id' when I look at the database thru the phpMyAdmin it doesn't show me a dupe column ... thanks again! I should have asked about this sooner and saved my teeth! kristy You need to tell it how to connect to your database. Edit config.inc.php: $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection // (requires PHP >= 4.3.0) $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings // (this user must have read-only $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" // and "mysql/db" tables). // The controluser is also // used for all relational // features (pmadb) $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = ''; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed Change host, user, and password to the values in your OSC includes/configure.php. Link to comment Share on other sites More sharing options...
musenut Posted November 12, 2006 Author Share Posted November 12, 2006 One more issue has cropped up (of course!) after manually installing the Separate Pricing per Customer contrib. it seems to be working but my scrollbars at the top level are gone - I can still scroll with arrow keys or the space bar but how where do I look to get the scroll bar working again? thanks! kristy the store resides at: http://www.desertbreeze-oat.com/store THANK YOU!!! I have been knashing my teeth for several days over this. What you gave me seems to have worked altho I got this error: #1060 - Duplicate column name 'customers_group_id' when I look at the database thru the phpMyAdmin it doesn't show me a dupe column ... thanks again! I should have asked about this sooner and saved my teeth! kristy Link to comment Share on other sites More sharing options...
musenut Posted November 12, 2006 Author Share Posted November 12, 2006 actually the scroll bars work fine in IE 6.0 and mac vers 5.2 It's firefox 1.5.0.8 and safari 1.3.2 on the mac that are not showing the scroll bars. any help appreciated - thanks! kristy One more issue has cropped up (of course!) after manually installing the Separate Pricing per Customer contrib. it seems to be working but my scrollbars at the top level are gone - I can still scroll with arrow keys or the space bar but how where do I look to get the scroll bar working again? thanks! kristy the store resides at: http://www.desertbreeze-oat.com/store Link to comment Share on other sites More sharing options...
kgt Posted November 13, 2006 Share Posted November 13, 2006 You have an embedded style: html { height: 100%; overflow: hidden; } "Overflow: hidden" hides the scroll bars. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
musenut Posted November 13, 2006 Author Share Posted November 13, 2006 :'( SOB!! I love you guys thank you! kristy You have an embedded style: html { height: 100%; overflow: hidden; } "Overflow: hidden" hides the scroll bars. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.