Re: Please help DB Error: unknown error

2003-11-18 Thread Matt W
Hi Thai,

I think you're just joining wy too many tables! LOL


Matt


- Original Message -
From: Thai Thanh Ha
Sent: Sunday, November 16, 2003 8:10 PM
Subject: Please help DB Error: unknown error


 Hi all,
 I have a problem with my query on mySQL 4.0.
 DB Error: unknown error
 I don't know what is the problem. Please help me!!! Thanks in advance.
 Regards,
 Thai
 SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
 t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile
t4,tblUserProfile
 t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile
t8,tblUserProfile
 t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile
t12,tblUserProfile
 t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile
t16,tblUserProfile
 t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile
t20,tblUserProfile
 t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile
t24,tblUserProfile
 t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile
t28,tblUserProfile
 t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile
t32,tblUserProfile
 t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile
t36,tblUserProfile
 t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile
t40,tblUserProfile
 t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile
t44,tblUserProfile
 t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile
t48,tblUserProfile
 t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile
t52,tblUserProfile
 t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile
t56,tblUserProfile
 t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile
t60,tblUserProfile
 t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile
t64,tblUserProfile
 t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile
t68,tblUserProfile
 t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile
t72,tblUserProfile
 t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile
t76,tblUserProfile
 t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile
t80,tblUserProfile
 t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile
t84,tblUserProfile
 t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile
t88,tblUserProfile
 t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile
t92,tblUserProfile
 t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile
t96,tblUserProfile
 t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile
t100,tblUserProfile
 t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
 t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
 t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
 t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
 t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
 t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
 t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
 t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
 t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
 t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
 t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
 t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
 t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
 t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
 t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
 t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
 t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
 t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
 t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
 t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
 tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle 
 'administrator' AND t.AccountType  2 AND t.AccountType  3 AND
t.Gender =
 1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID
=
 t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND
t1.UserID=t2.UserID
 AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
 t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND
t4.FieldID
 = 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78
AND
 t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
 t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
 t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
 t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
 t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
 t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.FieldID = 79 AND
 t11.FieldValue = 1 AND t1.UserID=t12.UserID AND t12.FieldID = 79 AND
 t12.FieldValue = 2 AND t1.UserID=t13.UserID AND t13.FieldID = 79 AND
 t13.FieldValue = 5 AND t1.UserID=t14.UserID AND t14.FieldID = 79 AND
 t14.FieldValue = 6 AND t1.UserID=t15.UserID AND t15.FieldID = 79 AND
 t15.FieldValue = 4 AND t1.UserID=t16.UserID AND t16.FieldID = 131 AND
 t16.FieldValue = 4 AND t1.UserID=t17.UserID AND t17.FieldID = 131 AND
 t17.FieldValue = 2 AND t1.UserID=t18.UserID AND t18.FieldID = 131

Re: Please help DB Error: unknown error

2003-11-18 Thread Reverend Deuce
Typically, this is the kind of query I see at MS-SQL houses. :)

-- R. Deuce


- Original Message - 
From: Matt W [EMAIL PROTECTED]
To: Thai Thanh Ha [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 5:28 PM
Subject: Re: Please help DB Error: unknown error


 Hi Thai,
 
 I think you're just joining wy too many tables! LOL
 
 
 Matt
 
 
 - Original Message -
 From: Thai Thanh Ha
 Sent: Sunday, November 16, 2003 8:10 PM
 Subject: Please help DB Error: unknown error
 
 
  Hi all,
  I have a problem with my query on mySQL 4.0.
  DB Error: unknown error
  I don't know what is the problem. Please help me!!! Thanks in advance.
  Regards,
  Thai
  SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
  t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile
 t4,tblUserProfile
  t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile
 t8,tblUserProfile
  t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile
 t12,tblUserProfile
  t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile
 t16,tblUserProfile
  t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile
 t20,tblUserProfile
  t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile
 t24,tblUserProfile
  t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile
 t28,tblUserProfile
  t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile
 t32,tblUserProfile
  t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile
 t36,tblUserProfile
  t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile
 t40,tblUserProfile
  t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile
 t44,tblUserProfile
  t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile
 t48,tblUserProfile
  t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile
 t52,tblUserProfile 

... snip ...


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Please help DB Error: unknown error

2003-11-18 Thread Paul DuBois
At 9:10 +0700 11/17/03, Thai Thanh Ha wrote:
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I don't know what is the problem. Please help me!!! Thanks in advance.
Joins can join up to 31 tables in MySQL.

Looks like you're exceeding that limit.

Regards,
Thai
SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile t4,tblUserProfile
t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile t8,tblUserProfile
t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile t12,tblUserProfile
t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile t16,tblUserProfile
t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile t20,tblUserProfile
t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile t24,tblUserProfile
t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile t28,tblUserProfile
t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile t32,tblUserProfile
t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile t36,tblUserProfile
t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile t40,tblUserProfile
t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile t44,tblUserProfile
t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile t48,tblUserProfile
t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile t52,tblUserProfile
t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile t56,tblUserProfile
t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile t60,tblUserProfile
t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile t64,tblUserProfile
t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile t68,tblUserProfile
t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile t72,tblUserProfile
t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile t76,tblUserProfile
t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile t80,tblUserProfile
t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile t84,tblUserProfile
t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile t88,tblUserProfile
t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile t92,tblUserProfile
t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile t96,tblUserProfile
t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile t100,tblUserProfile
t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle 
'administrator' AND t.AccountType  2 AND t.AccountType  3 AND t.Gender =
1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID =
t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND t1.UserID=t2.UserID
AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND t4.FieldID
= 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78 AND
t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.FieldID = 79 AND
t11.FieldValue = 1 AND t1.UserID=t12.UserID AND t12.FieldID = 79 AND
t12.FieldValue = 2 AND t1.UserID=t13.UserID AND t13.FieldID = 79 AND
t13.FieldValue = 5 AND t1.UserID=t14.UserID AND t14.FieldID = 79 AND
t14.FieldValue = 6 AND t1.UserID=t15.UserID AND t15.FieldID = 79 AND
t15.FieldValue = 4 AND t1.UserID=t16.UserID AND t16.FieldID = 131 AND
t16.FieldValue = 4 AND t1.UserID=t17.UserID AND t17.FieldID = 131 AND
t17.FieldValue = 2 AND t1.UserID=t18.UserID AND t18.FieldID = 131 AND
t18.FieldValue = 1 AND t1.UserID=t19.UserID AND t19.FieldID = 131 AND
t19.FieldValue = 3 AND t1.UserID=t20.UserID AND t20.FieldID = 137 AND

RE: Please help DB Error: unknown error

2003-11-17 Thread Victor Pendleton
Can you please post the error?

-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error


Hi all,
I have a problem with my query on mySQL 4.0. 
DB Error: unknown error 
I don't know what is the problem. Please help me!!! Thanks in advance.
Regards,
Thai
SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile t4,tblUserProfile
t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile t8,tblUserProfile
t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile t12,tblUserProfile
t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile t16,tblUserProfile
t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile t20,tblUserProfile
t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile t24,tblUserProfile
t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile t28,tblUserProfile
t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile t32,tblUserProfile
t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile t36,tblUserProfile
t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile t40,tblUserProfile
t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile t44,tblUserProfile
t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile t48,tblUserProfile
t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile t52,tblUserProfile
t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile t56,tblUserProfile
t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile t60,tblUserProfile
t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile t64,tblUserProfile
t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile t68,tblUserProfile
t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile t72,tblUserProfile
t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile t76,tblUserProfile
t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile t80,tblUserProfile
t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile t84,tblUserProfile
t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile t88,tblUserProfile
t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile t92,tblUserProfile
t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile t96,tblUserProfile
t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile t100,tblUserProfile
t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle 
'administrator' AND t.AccountType  2 AND t.AccountType  3 AND t.Gender =
1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID =
t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND t1.UserID=t2.UserID
AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND t4.FieldID
= 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78 AND
t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.FieldID = 79 AND
t11.FieldValue = 1 AND t1.UserID=t12.UserID AND t12.FieldID = 79 AND
t12.FieldValue = 2 AND t1.UserID=t13.UserID AND t13.FieldID = 79 AND
t13.FieldValue = 5 AND t1.UserID=t14.UserID AND t14.FieldID = 79 AND
t14.FieldValue = 6 AND t1.UserID=t15.UserID AND t15.FieldID = 79 AND
t15.FieldValue = 4 AND t1.UserID=t16.UserID AND t16.FieldID = 131 AND
t16.FieldValue = 4 AND t1.UserID=t17.UserID AND t17.FieldID = 131 AND
t17.FieldValue = 2 AND t1.UserID=t18.UserID AND t18.FieldID = 131 AND
t18.FieldValue = 1 AND t1.UserID=t19.UserID AND t19.FieldID

RE: Please help DB Error: unknown error

2003-11-17 Thread Thai Thanh Ha

 I see the only message DB Error: unknown error. Even when I run
mysqld.exe with --log and --error-log options, I still cannot get a more
descriptive error message. 

 I guess the problem is because of the number of joins is too large or the
number of *temporary* rows is too large. But I don't know how to resolve
this problem.

 Regards,
 Thai

-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 8:02 PM
To: 'Thai Thanh Ha'; '[EMAIL PROTECTED]'
Subject: RE: Please help DB Error: unknown error


Can you please post the error?

-Original Message-
From: Thai Thanh Ha [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 16, 2003 8:10 PM
To: '[EMAIL PROTECTED]'
Subject: Please help DB Error: unknown error


Hi all,
I have a problem with my query on mySQL 4.0. 
DB Error: unknown error 
I don't know what is the problem. Please help me!!! Thanks in advance.
Regards,
Thai
SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile t4,tblUserProfile
t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile t8,tblUserProfile
t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile t12,tblUserProfile
t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile t16,tblUserProfile
t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile t20,tblUserProfile
t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile t24,tblUserProfile
t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile t28,tblUserProfile
t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile t32,tblUserProfile
t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile t36,tblUserProfile
t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile t40,tblUserProfile
t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile t44,tblUserProfile
t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile t48,tblUserProfile
t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile t52,tblUserProfile
t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile t56,tblUserProfile
t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile t60,tblUserProfile
t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile t64,tblUserProfile
t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile t68,tblUserProfile
t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile t72,tblUserProfile
t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile t76,tblUserProfile
t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile t80,tblUserProfile
t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile t84,tblUserProfile
t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile t88,tblUserProfile
t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile t92,tblUserProfile
t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile t96,tblUserProfile
t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile t100,tblUserProfile
t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle 
'administrator' AND t.AccountType  2 AND t.AccountType  3 AND t.Gender =
1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID =
t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND t1.UserID=t2.UserID
AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND t4.FieldID
= 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78 AND
t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.FieldID

Please help DB Error: unknown error

2003-11-16 Thread Thai Thanh Ha
Hi all,
I have a problem with my query on mySQL 4.0. 
DB Error: unknown error 
I don't know what is the problem. Please help me!!! Thanks in advance.
Regards,
Thai
SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile
t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile t4,tblUserProfile
t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile t8,tblUserProfile
t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile t12,tblUserProfile
t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile t16,tblUserProfile
t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile t20,tblUserProfile
t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile t24,tblUserProfile
t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile t28,tblUserProfile
t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile t32,tblUserProfile
t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile t36,tblUserProfile
t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile t40,tblUserProfile
t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile t44,tblUserProfile
t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile t48,tblUserProfile
t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile t52,tblUserProfile
t53,tblUserProfile t54,tblUserProfile t55,tblUserProfile t56,tblUserProfile
t57,tblUserProfile t58,tblUserProfile t59,tblUserProfile t60,tblUserProfile
t61,tblUserProfile t62,tblUserProfile t63,tblUserProfile t64,tblUserProfile
t65,tblUserProfile t66,tblUserProfile t67,tblUserProfile t68,tblUserProfile
t69,tblUserProfile t70,tblUserProfile t71,tblUserProfile t72,tblUserProfile
t73,tblUserProfile t74,tblUserProfile t75,tblUserProfile t76,tblUserProfile
t77,tblUserProfile t78,tblUserProfile t79,tblUserProfile t80,tblUserProfile
t81,tblUserProfile t82,tblUserProfile t83,tblUserProfile t84,tblUserProfile
t85,tblUserProfile t86,tblUserProfile t87,tblUserProfile t88,tblUserProfile
t89,tblUserProfile t90,tblUserProfile t91,tblUserProfile t92,tblUserProfile
t93,tblUserProfile t94,tblUserProfile t95,tblUserProfile t96,tblUserProfile
t97,tblUserProfile t98,tblUserProfile t99,tblUserProfile t100,tblUserProfile
t101,tblUserProfile t102,tblUserProfile t103,tblUserProfile
t104,tblUserProfile t105,tblUserProfile t106,tblUserProfile
t107,tblUserProfile t108,tblUserProfile t109,tblUserProfile
t110,tblUserProfile t111,tblUserProfile t112,tblUserProfile
t113,tblUserProfile t114,tblUserProfile t115,tblUserProfile
t116,tblUserProfile t117,tblUserProfile t118,tblUserProfile
t119,tblUserProfile t120,tblUserProfile t121,tblUserProfile
t122,tblUserProfile t123,tblUserProfile t124,tblUserProfile
t125,tblUserProfile t126,tblUserProfile t127,tblUserProfile
t128,tblUserProfile t129,tblUserProfile t130,tblUserProfile
t131,tblUserProfile t132,tblUserProfile t133,tblUserProfile
t134,tblUserProfile t135,tblUserProfile t136,tblUserProfile
t137,tblUserProfile t138,tblUserProfile t139,tblUserProfile
t140,tblUserProfile t141,tblUserProfile t142,tblUserProfile
t143,tblUserProfile t144,tblUserProfile t145,tblUserProfile
t146,tblUserProfile t147,tblUserProfile t148,tblUserProfile
t149,tblUserProfile t150,tblUserProfile t151,tblUserProfile
t152,tblUserProfile t153,tblUserProfile t154,tblUserProfile
t155,tblUserProfile t156,tblUserProfile t157,tblUserProfile
t158,tblUserProfile t159,tblUserProfile t160,tblUserProfile t161,
tblMatchProfile mp WHERE t.ShowProfile = 1 AND t.LoginHandle 
'administrator' AND t.AccountType  2 AND t.AccountType  3 AND t.Gender =
1 AND (Year(Now()) - Year(t.BirthDate)) BETWEEN 18 AND 80 AND t.UserID =
t1.UserID AND t1.FieldID = 78 AND t1.FieldValue = 8 AND t1.UserID=t2.UserID
AND t2.FieldID = 78 AND t2.FieldValue = 6 AND t1.UserID=t3.UserID AND
t3.FieldID = 78 AND t3.FieldValue = 5 AND t1.UserID=t4.UserID AND t4.FieldID
= 78 AND t4.FieldValue = 3 AND t1.UserID=t5.UserID AND t5.FieldID = 78 AND
t5.FieldValue = 4 AND t1.UserID=t6.UserID AND t6.FieldID = 78 AND
t6.FieldValue = 7 AND t1.UserID=t7.UserID AND t7.FieldID = 78 AND
t7.FieldValue = 1 AND t1.UserID=t8.UserID AND t8.FieldID = 78 AND
t8.FieldValue = 9 AND t1.UserID=t9.UserID AND t9.FieldID = 78 AND
t9.FieldValue = 2 AND t1.UserID=t10.UserID AND t10.FieldID = 79 AND
t10.FieldValue = 3 AND t1.UserID=t11.UserID AND t11.FieldID = 79 AND
t11.FieldValue = 1 AND t1.UserID=t12.UserID AND t12.FieldID = 79 AND
t12.FieldValue = 2 AND t1.UserID=t13.UserID AND t13.FieldID = 79 AND
t13.FieldValue = 5 AND t1.UserID=t14.UserID AND t14.FieldID = 79 AND
t14.FieldValue = 6 AND t1.UserID=t15.UserID AND t15.FieldID = 79 AND
t15.FieldValue = 4 AND t1.UserID=t16.UserID AND t16.FieldID = 131 AND
t16.FieldValue = 4 AND t1.UserID=t17.UserID AND t17.FieldID = 131 AND
t17.FieldValue = 2 AND t1.UserID=t18.UserID AND t18.FieldID = 131 AND
t18.FieldValue = 1 AND t1.UserID=t19.UserID AND t19.FieldID = 131 AND
t19.FieldValue = 3 AND t1.UserID=t20.UserID AND t20.FieldID = 137 AND
t20.FieldValue = 12 AND t1.UserID=t21.UserID AND t21.FieldID = 137 AND
t21.FieldValue = 4 AND t1.UserID=t22.UserID AND t22.FieldID = 137