Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

phpMyAdmin doesn't see my database


musenut

Recommended Posts

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

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

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

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...