9 replies to this topic

[musenut]

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


kristy

[kgt]

musenut, on Nov 10 2006, 03:50 PM, said:

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


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.

[musenut]

kgt, on Nov 10 2006, 03:02 PM, said:

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?

[kgt]

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.

[Gameprodigy]

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.

[musenut]

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

kgt, on Nov 10 2006, 03:16 PM, said:

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.

[musenut]

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

musenut, on Nov 10 2006, 04:00 PM, said:

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

[musenut]

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

musenut, on Nov 12 2006, 08:40 AM, said:

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

[kgt]

You have an embedded style:

html {

		height: 100%;

		overflow: hidden;

	}

"Overflow: hidden" hides the scroll bars.

[musenut]

SOB!! I love you guys

thank you!
kristy

kgt, on Nov 13 2006, 08:12 AM, said:

You have an embedded style:

html {

		height: 100%;

		overflow: hidden;

	}

"Overflow: hidden" hides the scroll bars.