Forums / General Questions / Error message when deleting customers/newsletter in v1.2.6

Error message when deleting customers/newsletter in v1.2.6

Locked

Views: 1,086

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
25 Jan 2008, 4:19 AM
#1
honeysclerose avatar

honeysclerose

New Zenner

Join Date:
Jan 2006
Posts:
37
Plugin Contributions:
0

Error message when deleting customers/newsletter in v1.2.6

Version 1.2.6

When Im in admin and delete a customer I get a blank page with this at the top:
1054 Unknown column 'customer_id' in 'where clause'

I click the back arrow to get back to admin I have this message at the top:

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/cntrymea/public_html/dropship/admincp/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/cntrymea/public_html/dropship/admincp/includes/classes/object_info.php on line 30

The customer DOES get deleted from admin but NOT from the newsletter.

Is there a way to log into cpanel, find the newsletter module and delete ALL subscribers?
Since I have no clue (I didnt set up my cart way back when) I need suggestions (so I can forward them on to my web person) on where/how to find and fix this problem.

Many thanks.

25 Jan 2008, 2:48 PM
#2
absolute avatar

absolute

Totally Zenned

Join Date:
May 2005
Location:
Bath, Somerset
Posts:
1,054
Plugin Contributions:
2

Re: Error message when deleting customers/newsletter in v1.2.6

It sounds like the SQL you have running at teh top of the customers.php file has the wrong column name in it. Without seeing the rest of the SQ or the code it is fairly hard to give exact solutions. In the meantime, open up admin/customers.php and do a search for customer_id. This will appear in an SQL statement. Can you post that statement here?

Absolute

Back, after a 4 year absence! Did you miss me?
Absolute Web Solutions Ltd
Interested in our work? Take a look at one of our sites - The Tech Store

25 Jan 2008, 4:05 PM
#3
honeysclerose avatar

honeysclerose

New Zenner

Join Date:
Jan 2006
Posts:
37
Plugin Contributions:
0

Re: Error message when deleting customers/newsletter in v1.2.6

Thank You!
Im going to send your reply to my webperson as Im certain she will know how to do what you suggest.
Will let you know as soon as I hear back from her.

25 Jan 2008, 4:39 PM
#4
yellow1912 avatar

yellow1912

Totally Zenned

Join Date:
Oct 2006
Posts:
5,422
Plugin Contributions:
0

Re: Error message when deleting customers/newsletter in v1.2.6

1.2.6 is too old. Better upgrade it ASAP

I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me