Values from configuration table are not evaluated

[yoja]

Since I changed the DB password, all of a sudden my MS3 stopped working.

 

I'v been able to nail down the problem to this:

 

In application_top.php, the configuration values out of the configuration table are defined in this piece of code:

  
 while ($Qcfg->next()) {
   define($Qcfg->value('cfgKey'), $Qcfg->value('cfgValue'));
 }

 

This is where it fails, non of the cfg values are defined afterwards. If I put this in the code:

  while ($Qcfg->next()) {
 echo "in the loop?" . $Qcfg->value('cfgKey') . $Qcfg->value('cfgValue');
   define($Qcfg->value('cfgKey'), $Qcfg->value('cfgValue'));
 }

No output will occur, $Qcfg->next() is never true!

 

Above the code above is the code that queries the db:

 

// set application wide parameters
 $Qcfg = $osC_Database->query('select configuration_key as cfgKey, configuration_value as cfgValue from :table_configuration');
 $Qcfg->bindTable(':table_configuration', TABLE_CONFIGURATION);
 $Qcfg->setCache('configuration');
 $Qcfg->execute();

 

If I use a print_r afterwards:

	print_r($Qcfg);

 

I get this:

osc_database_result Object
(
   [db_class] => osc_database_mysql Object
       (
           [is_connected] => 1
           [link] => Resource id #10
           [error_number] => 
           [error] => 
           [error_reporting] => 1
           [server] => localhost
           [username] => ****
           [password] => ****
           [debug] => 
           [number_of_queries] => 0
           [time_of_queries] => 0
           [sql_parse_string] => mysql_real_escape_string
           [sql_parse_string_with_connection_handler] => 1
           [use_transactions] => 
       )

   [sql_query] => select configuration_key as cfgKey, configuration_value as cfgValue from osc_configuration
   [query_handler] => 
   [result] => 
   [rows] => 
   [affected_rows] => 
   [cache_key] => configuration
   [cache_expire] => 0
   [cache_data] => Array
       (
           [0] => 
       )

   [cache_read] => 1
   [debug] => 
   [batch_query] => 
   [batch_number] => 
   [batch_rows] => 
   [batch_size] => 
   [batch_to] => 
   [batch_from] => 
   [batch_select_field] => 
)

 

An empty cache_data!

 

The strange thing is that other queries are working perfectly! I can walk through the admin. (I can edit the my store preferences etc.) so there IS a working database connection.

 

Another thing that goes wrong as result of this is the default language:

ERROR_NO_DEFAULT_LANGUAGE_DEFINED

 

If i go to the shop, also the configuration files aren't read because off:

Warning: startservice(includes/modules/services/MODULE_SERVICES_INSTALLED.php): failed to open stream: No such file or directory in

And that makes also sense cause this is also set in the configuration file.

 

Who can help me??

[♥Vger]

MS3 is not a production (stable) release. It is a snapshot version only and not for use on functioning websites. There are pages with whole sections of code, covering certain functions, which just don't exist yet.

 

It will be quite some time before MS3 becomes the accepted standard release for osCommerce - even after it is officially released.

 

Vger

[yoja]

MS3 is not a production (stable) release.  It is a snapshot version only and not for use on functioning websites.  There are pages with whole sections of code, covering certain functions, which just don't exist yet.

<{POST_SNAPBACK}>

I know... it's not a production server. Just a test server. But it's strange this behaviour can occur only after changing a password. I was hoping someone had this before and knew how to solve it.

[mattice]

The configuration values are cached in the CVS snapshot you use.

Have you tried deleting the cache by using the refresh tool under

'Tools' ?

 

HTH

Matthijs