I am moving one of my directories to another server, and I somehow messed up the _email table. This is the error I get from debug mode:
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM elite_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/elitefan/public_html/classes/database.php on line 108
The table was accidentally dropped, and I created it manually. But apparently I missed something. The error doesn't appear everytime. When I reload the page it sometimes disappears.
Number of rows is for Unknown column 'headers' in 'field list'
Load time so far: 0.1 seconds. Performing query: UNLOCK TABLES;
Unknown column 'headers' in 'field list'
Load time so far: 0.1 seconds. Performing query: UPDATE elite_switches SET value='0' WHERE name='catselector';
Load time so far: 0.1 seconds. Performing query: SELECT id,frequency,filename,nextrun FROM elite_crons WHERE nextrun < 1141641864 ORDER BY id ASC LIMIT 0,1;
argh, this is stupid! I didn't understand why thaz error was showing up, because the 'headers' field was there. Now I finally saw that it was actually called 'header'. I forgot the 's'. Sorry ...
Load time so far: 0.14 seconds. Performing query: SELECT COUNT(*) FROM agents WHERE email = 'max@sc.rr.com' AND allowemail != 'no' AND validated=1 AND banned='' ; Count is 1
Load time so far: 0.15 seconds. Performing query: SELECT id,email FROM agents WHERE email = 'max@sc.rr.com' AND allowemail != 'no' AND validated=1 AND banned='' ORDER BY id ASC LIMIT 0,20000;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/zaemxlth/public_html/ads/classes/database.php on line 108
Number of rows is for Unknown column 'id' in 'field list'
Sending e-mail titled to , From: c21ccp@sc.rr.com with replacements member for and mime setting 1. Contents: Use any member template variables in this message that you want to use to show info about the member. When linking to something on your site, be sure to use http://www.c21coastallifestyles.net/ads in front of the file name so that you'll have an absolute path. Now, replace this text with the actual message you want to send.
Load time so far: 0.2 seconds. Performing query: INSERT INTO wsnlinks_email(id,`to`,subject,message,headers,timesent,ip,replacement,mime) VALUES('','','','Use any member template variables in this message that you want to use to show info about the member. When linking to something on your site, be sure to use http://www.c21coastallifestyles.net/ads in front of the file name so that you'll have an absolute path. Now, replace this text with the actual message you want to send. ','From: c21ccp@sc.rr.com','0','70.60.214.13','member for ','1');
Unknown column 'id' in 'field list'
but since I used integration my id filed is different and it is mentioned in the integration config file as newid. Looks like its not propagating correctly into the email script..
Performing query: SELECT id,email FROM agents WHERE email = 'max@sc.rr.com' AND allowemail != 'no' AND validated=1 AND banned='' ORDER BY id ASC LIMIT 0,20000;
This looks like something generated by a specific page, not every email, so I obviously can't do anything when you fail to tell me what page you're dealing with.
o-o, do I need to download a new update now? Paul, how about creating a plugin module or something - I have to add all my custom functions manually every time I update the script. Then we could share our plugins too. Kinda like Wordpress does.
Comments on Messed up _email table
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
I am moving one of my directories to another server, and I somehow messed up the _email table. This is the error I get from debug mode:
The table was accidentally dropped, and I created it manually. But apparently I missed something. The error doesn't appear everytime. When I reload the page it sometimes disappears.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Is there a more specific mysql message below that? Normally it should have the output of mysqlerror() somewhere below the warning notice.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
These are the next few lines posted:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It says your table lacks the headers field.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
argh, this is stupid! I didn't understand why thaz error was showing up, because the 'headers' field was there. Now I finally saw that it was actually called 'header'. I forgot the 's'. Sorry ...
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
I have a similar problem
but since I used integration my id filed is different and it is mentioned in the integration config file as newid. Looks like its not propagating correctly into the email script..
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Load time so far: 0.15 seconds.
Performing query: SELECT id,email FROM agents WHERE email = 'max@sc.rr.com' AND allowemail != 'no' AND validated=1 AND banned='' ORDER BY id ASC LIMIT 0,20000;
This looks like something generated by a specific page, not every email, so I obviously can't do anything when you fail to tell me what page you're dealing with.
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
I'm just trying to send email from the admin panel to a specific member with specific email address.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Okay then, fixed.
Forum Regular
Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Comments: 197
o-o, do I need to download a new update now?
Paul, how about creating a plugin module or something - I have to add all my custom functions manually every time I update the script. Then we could share our plugins too. Kinda like Wordpress does.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There is a modifications directory already, you should use it.