Error codes when using Xampp ?

[Mort-lemur]

Hi,

 

Im trying to set up a mirror of my store on my desktop using Xampp so I can try out mods offline first.

 

However I am getting lots of error messages at the top of the page and in the L & R Coloums. The error messages are all in the same format but relate to errors in a handful of files:

 

Deprecated: Function ereg_replace() is deprecated in C:\xampp\htdocs\includes\functions\dynamenu\lib\layersmenu-common.inc.php on line 487

 

What is causing this?

 

Thanks

[FIMBLE]

Hi

I expect you have installed a new version of XAMPP, in this it has the latest php, where the regex functions are not supported any longer.

You will need to either install an earlier version of XAMPP or go through the code and change one by one the regex

see this page http://php.net/manual/en/function.ereg.php

Probably be easier if you install an older version of XAMPP

Nic

[BryceJr]

Instructions to download older XAMPP version ->here

[Mort-lemur]

Hi,

 

Downloaded the older Xampp and set up the config files as per in the forums and everything seems to work ok on the shop side. So thats great - thanks :-)

 

However, I am getting a few errors when using the admin side, such as :

 

1054 - Unknown column 'customers_info_source_id' in 'field list'

 

select customers_info_source_id from customers_info where customers_info_id = '37'

 

[TEP STOP]

when accessing the customers area. and:

 

1054 - Unknown column 'o.customer_service_id' in 'field list'

 

select o.customer_service_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit 0, 20

 

[TEP STOP]

when accessing the orders area

 

Are there any other files where I need to change the absolute paths?

 

Thanks

[FIMBLE]

Hi,

 

Downloaded the older Xampp and set up the config files as per in the forums and everything seems to work ok on the shop side. So thats great - thanks :-)

 

However, I am getting a few errors when using the admin side, such as :

 

1054 - Unknown column 'customers_info_source_id' in 'field list'

 

select customers_info_source_id from customers_info where customers_info_id = '37'

 

[TEP STOP]

when accessing the customers area. and:

 

1054 - Unknown column 'o.customer_service_id' in 'field list'

 

select o.customer_service_id, o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit 0, 20

 

[TEP STOP]

when accessing the orders area

 

Are there any other files where I need to change the absolute paths?

 

Thanks

 

Morning

It appears to be a contribution added in code, but not to the Dbase, column customer_service_id is missing, go over the contributions you have added to look for missed SQL updates.

Nic

[Mort-lemur]

Morning

It appears to be a contribution added in code, but not to the Dbase, column customer_service_id is missing, go over the contributions you have added to look for missed SQL updates.

Nic

 

Thanks again. Looks like I used a copy of the database that was a couple of days out of date, and missing the order editor and order maker mods.

 

Now working just great.

 

Thankyou

[ce7]

@ Mort-lemur

 

Hi I have the same error,

 

can you please share how you fix it? Many thanks in advance.

 

Lyn