mariovaldez.net
http://www.mariovaldez.net/webapps/forums/

Help me please
http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=12&t=776		 Page 1 of 1
Author:  Thrifaze [ 17 Mar 2007, 09:55 ]
Post subject:  Help me please
Hi everyone,

First of all thank a lot for the contribution.

I have a problem, I have installed the software, then I enter the connections data, it seems to be ok cause the software connects to my database, but then there is nothing. I mean there are no product in the list, even when I do "refresh category list", it refresh but nothing appears.

I use the last version 0.4.1

I guess the software cannot retrieve the product list. But why I need some help to know.

Thank
Bye
Author:  Tozi [ 19 Mar 2007, 07:09 ]
Post subject: 
I have same problem here, downloaded the latest, installed.
It seems it's collecting all the data, but everything is blank.
I tried changing username and still same, so it seems it's not connecting to server/database.

Please advice?
Author:  zenbuddha [ 21 Jun 2007, 06:02 ]
Post subject: 
I have same problem :(
I use version 0.4.1
Author:  mvaldez [ 27 Jun 2007, 02:14 ]
Post subject:  To all you having connection problems...
Hi, to all users having connections problems, try the following steps:

0) First, download the latest version and install. Don't forget to upload the server-side script to your store web server.

1) Open the server-side script in your web browser and check that everything is Ok. If you see any error message, that can give you a clue about the problem.

2) Check the configuration options, specially the two URLs (server-side script and image directory). Just to be sure, copy the URLs from the configuration window to your browser and check that it loads properly. Too many times the problem is just a mistyped URL.

3) If you are behind a firewall or proxy the connection may fail. Check with your network administrator and set the proxy options in the configuration window.

4) If you can connect but nothing is shown, check the language menu in the toolbar and set it to the proper language.

5) In the configuration window, enable the SQL log feature. Then disconnect and try to connect again. Then check the option Tools > SQL Log. Then send me the file (compressed, please!) to mario@mariovaldez.org so I can try to help you figure out what is the problem.


Regards,

Mario A. Valdez-Ramirez.
Author:  Guest [ 15 Jul 2007, 22:47 ]
Post subject:  Re: To all you having connection problems...
i faced the exact problem ....
here's my SQL log:

Code:
2007-07-16 13:34:56:000
======================================

2007-07-16 13:35:00:328|BEGIN record loading (LoadLangList)...
2007-07-16 13:35:00:328|Executing query: select languages_id, name from languages order by name
2007-07-16 13:35:00:328|Try 0 Ready... set...
2007-07-16 13:35:00:328|Go!
2007-07-16 13:35:00:625|Done!
2007-07-16 13:35:00:625|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:00:625|END record loading.
2007-07-16 13:35:00:640|BEGIN record loading (LoadCatList)...
2007-07-16 13:35:00:640|Executing query: select categories.categories_id, categories.parent_id, categories_description.categories_name from categories, categories_description where categories_description.categories_id= categories.categories_id and language_id=1 ORDER BY categories.parent_id, categories_description.categories_name
2007-07-16 13:35:00:640|Try 0 Ready... set...
2007-07-16 13:35:00:640|Go!
2007-07-16 13:35:00:937|Done!
2007-07-16 13:35:00:937|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:00:937|BEGIN record loading (LoadManList)...
2007-07-16 13:35:00:937|Executing query: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
2007-07-16 13:35:00:937|Try 0 Ready... set...
2007-07-16 13:35:00:937|Go!
2007-07-16 13:35:01:234|Done!
2007-07-16 13:35:01:234|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:01:250|BEGIN record loading (LoadTaxList)...
2007-07-16 13:35:01:250|Executing query: select tax_class.tax_class_id, tax_class_title, sum(tax_rate) from (tax_class) left join tax_rates on tax_class.tax_class_id=tax_rates.tax_class_id group by tax_class_id order by tax_class_title
2007-07-16 13:35:01:250|Try 0 Ready... set...
2007-07-16 13:35:01:250|Go!
2007-07-16 13:35:01:546|Done!
2007-07-16 13:35:01:546|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:01:546|BEGIN record loading (LoadDefCurrency)...
2007-07-16 13:35:01:546|Executing query: select currencies.currencies_id from currencies, configuration where configuration.configuration_key="DEFAULT_CURRENCY" and configuration.configuration_value=currencies.code
2007-07-16 13:35:01:546|Try 0 Ready... set...
2007-07-16 13:35:01:546|Go!
2007-07-16 13:35:01:859|Done!
2007-07-16 13:35:01:859|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:01:859|BEGIN record loading (LoadCurrencyList)...
2007-07-16 13:35:01:859|Executing query: select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies order by title, code
2007-07-16 13:35:01:859|Try 0 Ready... set...
2007-07-16 13:35:01:859|Go!
2007-07-16 13:35:02:156|Done!
2007-07-16 13:35:02:156|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:02:171|RenderLanguageDisplay BEGIN
2007-07-16 13:35:02:171|RenderLanguageDisplay END
2007-07-16 13:35:02:171|RenderCategoryDisplay BEGIN
2007-07-16 13:35:02:171|RenderCategoryDisplay END




mvaldez wrote:
Hi, to all users having connections problems, try the following steps:

0) First, download the latest version and install. Don't forget to upload the server-side script to your store web server.

1) Open the server-side script in your web browser and check that everything is Ok. If you see any error message, that can give you a clue about the problem.

2) Check the configuration options, specially the two URLs (server-side script and image directory). Just to be sure, copy the URLs from the configuration window to your browser and check that it loads properly. Too many times the problem is just a mistyped URL.

3) If you are behind a firewall or proxy the connection may fail. Check with your network administrator and set the proxy options in the configuration window.

4) If you can connect but nothing is shown, check the language menu in the toolbar and set it to the proper language.

5) In the configuration window, enable the SQL log feature. Then disconnect and try to connect again. Then check the option Tools > SQL Log. Then send me the file (compressed, please!) to mario@mariovaldez.org so I can try to help you figure out what is the problem.


Regards,

Mario A. Valdez-Ramirez.
Code:
Code:
Author:  travelguy [ 15 Jul 2007, 22:49 ]
Post subject:  Re: To all you having connection problems...
I faced the exact problem as the previous user, I use the last version 0.4.1
here's the my sql log:

Code:
2007-07-16 13:34:56:000
======================================

2007-07-16 13:35:00:328|BEGIN record loading (LoadLangList)...
2007-07-16 13:35:00:328|Executing query: select languages_id, name from languages order by name
2007-07-16 13:35:00:328|Try 0 Ready... set...
2007-07-16 13:35:00:328|Go!
2007-07-16 13:35:00:625|Done!
2007-07-16 13:35:00:625|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:00:625|END record loading.
2007-07-16 13:35:00:640|BEGIN record loading (LoadCatList)...
2007-07-16 13:35:00:640|Executing query: select categories.categories_id, categories.parent_id, categories_description.categories_name from categories, categories_description where categories_description.categories_id= categories.categories_id and language_id=1 ORDER BY categories.parent_id, categories_description.categories_name
2007-07-16 13:35:00:640|Try 0 Ready... set...
2007-07-16 13:35:00:640|Go!
2007-07-16 13:35:00:937|Done!
2007-07-16 13:35:00:937|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:00:937|BEGIN record loading (LoadManList)...
2007-07-16 13:35:00:937|Executing query: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
2007-07-16 13:35:00:937|Try 0 Ready... set...
2007-07-16 13:35:00:937|Go!
2007-07-16 13:35:01:234|Done!
2007-07-16 13:35:01:234|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:01:250|BEGIN record loading (LoadTaxList)...
2007-07-16 13:35:01:250|Executing query: select tax_class.tax_class_id, tax_class_title, sum(tax_rate) from (tax_class) left join tax_rates on tax_class.tax_class_id=tax_rates.tax_class_id group by tax_class_id order by tax_class_title
2007-07-16 13:35:01:250|Try 0 Ready... set...
2007-07-16 13:35:01:250|Go!
2007-07-16 13:35:01:546|Done!
2007-07-16 13:35:01:546|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:01:546|BEGIN record loading (LoadDefCurrency)...
2007-07-16 13:35:01:546|Executing query: select currencies.currencies_id from currencies, configuration where configuration.configuration_key="DEFAULT_CURRENCY" and configuration.configuration_value=currencies.code
2007-07-16 13:35:01:546|Try 0 Ready... set...
2007-07-16 13:35:01:546|Go!
2007-07-16 13:35:01:859|Done!
2007-07-16 13:35:01:859|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:01:859|BEGIN record loading (LoadCurrencyList)...
2007-07-16 13:35:01:859|Executing query: select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies order by title, code
2007-07-16 13:35:01:859|Try 0 Ready... set...
2007-07-16 13:35:01:859|Go!
2007-07-16 13:35:02:156|Done!
2007-07-16 13:35:02:156|Decoded records: 0x0 Size: 0 Original size: 0
2007-07-16 13:35:02:171|RenderLanguageDisplay BEGIN
2007-07-16 13:35:02:171|RenderLanguageDisplay END
2007-07-16 13:35:02:171|RenderCategoryDisplay BEGIN
2007-07-16 13:35:02:171|RenderCategoryDisplay END



mvaldez wrote:
Hi, to all users having connections problems, try the following steps:

0) First, download the latest version and install. Don't forget to upload the server-side script to your store web server.

1) Open the server-side script in your web browser and check that everything is Ok. If you see any error message, that can give you a clue about the problem.

2) Check the configuration options, specially the two URLs (server-side script and image directory). Just to be sure, copy the URLs from the configuration window to your browser and check that it loads properly. Too many times the problem is just a mistyped URL.

3) If you are behind a firewall or proxy the connection may fail. Check with your network administrator and set the proxy options in the configuration window.

4) If you can connect but nothing is shown, check the language menu in the toolbar and set it to the proper language.

5) In the configuration window, enable the SQL log feature. Then disconnect and try to connect again. Then check the option Tools > SQL Log. Then send me the file (compressed, please!) to mario@mariovaldez.org so I can try to help you figure out what is the problem.


Regards,

Mario A. Valdez-Ramirez.
Author:  mvaldez [ 16 Jul 2007, 12:20 ]
Post subject:  Empty language list...
TravelGuy:

The application is not getting any language from the database, that's why everything appears empty. The failing SQL query is the first one (select languages_id, name from languages order by name).

Do you have phpMyAdmin installed in your osCommerce server. I would like you to run manually that SQL query to check what does your MySQL server answer.

Optionally, you can make a backup of your database (using the osCommerce Backup option in the Tools section of the Admin panel). Then download the backup, uncompress it, open the .sql file in a text editor (but avoid Windows' Notepad) and look for the language table definition and content. Then send me that segment of the backup. Please don't send me the whole backup file, as it would contain private or confidential information about your customers.

By the way, is your osCommerce store a normal osCommerce or a variant? Also, how many languages does it have?

Please let me know what you find or if you need any help.


Regards,

Mario A. Valdez-Ramirez.
Author:  rmlayton [ 26 Jul 2007, 14:14 ]
Post subject:  Same Problem - empty screen
I am experiencing the same problem. Since TravelGuy has not responded let me furnish you with the sql you requested :

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 26, 2007 at 03:13 PM
-- Server version: 4.1.9
-- PHP Version: 4.4.2
--
-- Database: `oscommerce`
--

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
`languages_id` int(11) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default '',
`code` char(2) NOT NULL default '',
`image` varchar(64) default NULL,
`directory` varchar(32) default NULL,
`sort_order` int(3) default NULL,
PRIMARY KEY (`languages_id`),
KEY `IDX_LANGUAGES_NAME` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1);
Author:  rmlayton [ 26 Jul 2007, 14:29 ]
Post subject:  Same Problem - empty screen (cont.)
I tested all of the sql statements in the log with phpMyAdmin. They all work and I get data. I also tested the serverside script and got no errors.

Although the connection appears to work, the issue must be in the connection or interface.

Since several people are having the issue and some are not, could it be a version issue? I am running osCommerce 2.2 with MySQL4 version 4.1.9.
Author:  mvaldez [ 26 Jul 2007, 16:18 ]
Post subject:  Empty language list... test the latest beta version...
rmlayton:

> I tested all of the sql statements in the log with phpMyAdmin.
> They all work and I get data. I also tested the serverside script
> and got no errors. Although the connection appears to work, the
> issue must be in the connection or interface. Since several people
> are having the issue and some are not, could it be a version issue?
> I am running osCommerce 2.2 with MySQL4 version 4.1.9.

Hi. Please try the latest beta version (at this time is 0.4.1.816) from:

http://www.mariovaldez.net/software/osc ... _versions/

Why? Because I have added a new MySQL back-end interface to the server-side script, and because the SQL error reporting has been improved a lot (in previous versions, sometimes SQL errors were not properly detected by the application).

Install the latest beta version, update the server-side script and then enable the SQL log in the OSCPMWin application and then try to connect.

And let me know if it does work. If it does not, please check the SQL log and send it to me (mario@mariovaldez.org).



Regards,

Mario A. Valdez-Ramirez.
Author:  rmlayton [ 27 Jul 2007, 07:24 ]
Post subject:  new version failed
I uninstalled the olded version and installed the beta version.

When I log in the popup box says "connecting" and the status bars goes about 20% and it goes away. No error message. If you go to the menu, "Connect" is still the available selection. I set SQL Logging and this is what I get:

2007-07-27 10:04:19:023
======================================

2007-07-27 10:05:23:066|BEGIN record loading (LoadTableNames)...
2007-07-27 10:05:23:300|Missing database table names...
2007-07-27 10:05:23:315|END record loading.

A couple of things I observed.

1. In the new version, the database tables tab is missing from the configuration file.
2. In .683, I was logging using the user/password I use with phpMyAdmin, but in .816 this gave me a password error, but there is an OSCPMCHECKER record in whos_online.
3. In .683, both passwords behave the same.

My best guess is that the missing tab on the configuration and the SQL error are related.

I really appreciate the job you do and I am sure that this will be a great application once I figure out how to get it installed.

Ron
Author:  mvaldez [ 27 Jul 2007, 10:25 ]
Post subject:  debugging the
Ron:

> 2007-07-27 10:05:23:066|BEGIN record loading (LoadTableNames)...
> 2007-07-27 10:05:23:300|Missing database table names...
> 2007-07-27 10:05:23:315|END record loading.

Mmmmh... ok, that's weird. The new beta version does not need to have the table names configured manually, as now it ask the server-side script which are the database table names. That message means the OSCPMWin application could not get the data from the server-side script.


> 1. In the new version, the database tables tab is missing
> from the configuration file.

As explained above, this is Ok.


> 2. In .683, I was logging using the user/password I use with
> phpMyAdmin, but in .816 this gave me a password error, but
> there is an OSCPMCHECKER record in whos_online.

The password should be the same password used by the osCommerce store. Security is the only reason for that. The server-side script never receive the username and password from the OSCPMWin application (they are never sent); it takes that information from the osCommerce configuration files directly. The OSCPMWin application requires the password only to create a cryptographic salted-hash and then send that to the server, which can confirm is the hash can be made with the osCommerce password or not.

The OSCPMCHECKER record in whos_online is a login attempt record. If you try to login too many times and fails (eight times by default) in a certain period of time (less five minutes between attemps), the server-side script will refuse additional connections from your IP address for certain amount of time (one hour by default). So, it is a security feature to stop dictionary (password-guessing) attacks against the server-side script. That information is managed by the server-side script.


> 3. In .683, both passwords behave the same. My best guess is
> that the missing tab on the configuration and the SQL error are
> related.

Please use the password used by your osCommerce store.

Also, you may try the server-side logging. Just edit the server-side script and change the following variables:

opm_enable_logfile = false;
opm_enable_extralog = false;
opm_enable_recordsetlog = false;

Change them all to true. Then try to connect with the OSCPMWin application. A file named opm_debug.txt will be created in the osCommerce directory in your server. As soon as you get the file, disable the server logging, as it can grow very large quickly and reduce the performance of the server-side script.

Please note that for the log file to be created, the osCommerce directory should have writting permissions for the web server. If you don't want to change the permissions of the directory, then upload an empty file with the opm_debug.txt name and then change the permissions of that file only, so that it can be written by the web server.


For this test, please modify the server-side script in the following block (around line 680), find:

Code:
if ($opm_operation == "tables") {
  opm_FNDebug_Log ("$opm_ok_string Tables listing started.");
  echo "$opm_ok_string TABLES START\n";
  // Table names...
  echo "TABLE_CATEGORIES=" . TABLE_CATEGORIES . "\n";
  echo "TABLE_CATEGORIES_DESCRIPTION=" . TABLE_CATEGORIES_DESCRIPTION . "\n";
  echo "TABLE_CONFIGURATION=" . TABLE_CONFIGURATION . "\n";
  echo "TABLE_CURRENCIES=" . TABLE_CURRENCIES . "\n";
  echo "TABLE_LANGUAGES=" . TABLE_LANGUAGES . "\n";
  echo "TABLE_MANUFACTURERS=" . TABLE_MANUFACTURERS . "\n";
  echo "TABLE_MANUFACTURERS_INFO=" . TABLE_MANUFACTURERS_INFO . "\n";
  echo "TABLE_PRODUCTS=" . TABLE_PRODUCTS . "\n";
  echo "TABLE_PRODUCTS_DESCRIPTION=" . TABLE_PRODUCTS_DESCRIPTION . "\n";
  echo "TABLE_PRODUCTS_TO_CATEGORIES=" . TABLE_PRODUCTS_TO_CATEGORIES . "\n";
  echo "TABLE_SPECIALS=" . TABLE_SPECIALS . "\n";
  echo "TABLE_TAX_CLASS=" . TABLE_TAX_CLASS . "\n";
  echo "TABLE_TAX_RATES=" . TABLE_TAX_RATES . "\n";
  opm_FNDebug_Log ("$opm_ok_string Tables listing finished.");
  echo "$opm_ok_string TABLES END\n";
}



...and replace it with this:

Code:
if ($opm_operation == "tables") {
  opm_FNDebug_Log ("$opm_ok_string Tables listing started.");
  echo "$opm_ok_string TABLES START\n";
  // Table names...
  $opm_tables_list = "TABLE_CATEGORIES=" . TABLE_CATEGORIES . "\n";
  $opm_tables_list .= "TABLE_CATEGORIES_DESCRIPTION=" . TABLE_CATEGORIES_DESCRIPTION . "\n";
  $opm_tables_list .= "TABLE_CONFIGURATION=" . TABLE_CONFIGURATION . "\n";
  $opm_tables_list .= "TABLE_CURRENCIES=" . TABLE_CURRENCIES . "\n";
  $opm_tables_list .= "TABLE_LANGUAGES=" . TABLE_LANGUAGES . "\n";
  $opm_tables_list .= "TABLE_MANUFACTURERS=" . TABLE_MANUFACTURERS . "\n";
  $opm_tables_list .= "TABLE_MANUFACTURERS_INFO=" . TABLE_MANUFACTURERS_INFO . "\n";
  $opm_tables_list .= "TABLE_PRODUCTS=" . TABLE_PRODUCTS . "\n";
  $opm_tables_list .= "TABLE_PRODUCTS_DESCRIPTION=" . TABLE_PRODUCTS_DESCRIPTION . "\n";
  $opm_tables_list .= "TABLE_PRODUCTS_TO_CATEGORIES=" . TABLE_PRODUCTS_TO_CATEGORIES . "\n";
  $opm_tables_list .= "TABLE_SPECIALS=" . TABLE_SPECIALS . "\n";
  $opm_tables_list .= "TABLE_TAX_CLASS=" . TABLE_TAX_CLASS . "\n";
  $opm_tables_list .= "TABLE_TAX_RATES=" . TABLE_TAX_RATES . "\n";
  echo $opm_tables_list;
  opm_FNDebug_Log ("$opm_tables_list");
  opm_FNDebug_Log ("$opm_ok_string Tables listing finished.");
  echo "$opm_ok_string TABLES END\n";
}


This will allow the logging of the database table names as found by the server-side script.


Please let me know what you find.



Regards,

Mario A. Valdez-Ramirez
Author:  rmlayton [ 27 Jul 2007, 11:47 ]
Post subject:  Error Log
The only thing that apears a little strange is the the REALPATH seems to point to the images directory, but after looking at the code that appears to be normal.

Other than that it appears to have found the table names.

I hope this makes sense to you and gets us a little closer to fixing it:

2007-07-27 12:32:17: Array
(
[Un] => 5B11F4A1CC616242D56D4E47D6726A20
[Pw] => 8341A5079CFD2BA1A1A7BFAD7F5EBC4A
[Op] => noop
[Fn] =>
[Vn] => 0.9.6
[TS] => 2007-07-27 14:29:29.953
)

2007-07-27 12:32:17: REALPATH=/var/www/html/catalog/images/
2007-07-27 12:32:17: PASSWORDHASH=8341A5079CFD2BA1A1A7BFAD7F5EBC4A
2007-07-27 12:32:17: OPERATION=noop
2007-07-27 12:32:17: FILENAME=
2007-07-27 12:32:17: SUBDIR=
2007-07-27 12:32:17: QUERY=
2007-07-27 12:32:17: REQVERSION=0.9.6
2007-07-27 12:32:17: LOGINTIMESTAMP=2007-07-27 14:29:29.953
2007-07-27 12:32:17: COMPRESS=
2007-07-27 12:32:17: SERVERPASSWORDHASH=8341A5079CFD2BA1A1A7BFAD7F5EBC4A
2007-07-27 12:32:17: MVOSCPM1_NOERROR NOOP requested.
2007-07-27 12:32:18: Array
(
[Un] => 1E9BBE6E42432A822726A4C0C785ABDB
[Pw] => 7F13EB04ED161705090EB46E734BD9E7
[Op] => capa
[Fn] =>
[Vn] => 0.9.6
[TS] => 2007-07-27 14:29:30.219
)

2007-07-27 12:32:18: REALPATH=/var/www/html/catalog/images/
2007-07-27 12:32:18: PASSWORDHASH=7F13EB04ED161705090EB46E734BD9E7
2007-07-27 12:32:18: OPERATION=capa
2007-07-27 12:32:18: FILENAME=
2007-07-27 12:32:18: SUBDIR=
2007-07-27 12:32:18: QUERY=
2007-07-27 12:32:18: REQVERSION=0.9.6
2007-07-27 12:32:18: LOGINTIMESTAMP=2007-07-27 14:29:30.219
2007-07-27 12:32:18: COMPRESS=
2007-07-27 12:32:18: SERVERPASSWORDHASH=7F13EB04ED161705090EB46E734BD9E7
2007-07-27 12:32:18: MVOSCPM1_NOERROR Capability search started.
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_PAYMENT_CC_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=6
2007-07-27 12:32:18: MVOSCPM1_NOERROR PAY_CC capability found.
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_PAYMENT_MONEYORDER_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=6
2007-07-27 12:32:18: MVOSCPM1_NOERROR PAY_ORDER capability found.
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_PAYMENT_COD_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=6
2007-07-27 12:32:18: MVOSCPM1_NOERROR PAY_CC capability found.
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_PAYMENT_PAYPAL_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_SHIPPING_FLAT_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_SHIPPING_TABLE_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=5
2007-07-27 12:32:18: MVOSCPM1_NOERROR SHIP_TBL capability found.
2007-07-27 12:32:18: SQLQUERY=select configuration_value from configuration where configuration_key = 'MODULE_SHIPPING_SPU_STATUS'
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=show tables like 'stores'
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=describe products products_subimage6
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=describe customers customers_groups_id
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=show tables like 'phesis_poll_config'
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: SQLQUERY=describe products_description products_head_keywords_tag
2007-07-27 12:32:18: RECORDSET SIZE=0
2007-07-27 12:32:18: MVOSCPM1_NOERROR Capability search finished.
2007-07-27 12:32:18: Array
(
[Un] => E2F918F1045B91783CF7A7108C33C8F5
[Pw] => 8924E1C6ABB045E1CA20E37174D56E28
[Op] => tables
[Fn] =>
[Vn] => 0.9.6
[TS] => 2007-07-27 14:29:30.486
)

2007-07-27 12:32:18: REALPATH=/var/www/html/catalog/images/
2007-07-27 12:32:18: PASSWORDHASH=8924E1C6ABB045E1CA20E37174D56E28
2007-07-27 12:32:18: OPERATION=tables
2007-07-27 12:32:18: FILENAME=
2007-07-27 12:32:18: SUBDIR=
2007-07-27 12:32:18: QUERY=
2007-07-27 12:32:18: REQVERSION=0.9.6
2007-07-27 12:32:18: LOGINTIMESTAMP=2007-07-27 14:29:30.486
2007-07-27 12:32:18: COMPRESS=
2007-07-27 12:32:18: SERVERPASSWORDHASH=8924E1C6ABB045E1CA20E37174D56E28
2007-07-27 12:32:18: MVOSCPM1_NOERROR Tables listing started.
2007-07-27 12:32:18: TABLE_CATEGORIES=categories
TABLE_CATEGORIES_DESCRIPTION=categories_description
TABLE_CONFIGURATION=configuration
TABLE_CURRENCIES=currencies
TABLE_LANGUAGES=languages
TABLE_MANUFACTURERS=manufacturers
TABLE_MANUFACTURERS_INFO=manufacturers_info
TABLE_PRODUCTS=products
TABLE_PRODUCTS_DESCRIPTION=products_description
TABLE_PRODUCTS_TO_CATEGORIES=products_to_categories
TABLE_SPECIALS=specials
TABLE_TAX_CLASS=tax_class
TABLE_TAX_RATES=tax_rates

2007-07-27 12:32:18: MVOSCPM1_NOERROR Tables listing finished.
Author:  mvaldez [ 27 Jul 2007, 13:24 ]
Post subject:  Test with one of my test stores...
Ron:

Please send me an email (mario@mariovaldez.org) so I can send you the information about how to connect to one of my test osCommerce stores, so you can try to connect to it and check if this is a server-side problem or a client problem.


Regards,

Mario A. Valdez-Ramirez.
Author:  rmlayton [ 31 Jul 2007, 14:28 ]
Post subject:  just checking in
Mario,
We are sure now that it is a serverside issue. I sent an email with my findings and some configuration information. I have not heard anything and wanted to be sure you got it. Ron
Author:  milionking [ 30 Nov 2007, 21:19 ]
Post subject:  Potential Cause of connection
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in F:\hshome\milionking\michigansoftwaredealer.com\catalog\includes\functions\database.php on line 19
ERROR 1031 NO DATABASE CONNECTION

I get this error when attempting to execute the server side script post-installation. Thoughts?
Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/