- assigned_to: nobody --> squareing
- status: open --> closed-fixed
This error occured after logging in as admin on a brand
new install.
#### USER AGENT: Mozilla/5.0 (Windows; U; Windows NT
5.1; en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6
#### ACCT: ID: 2 - Login: admin - e-mail:
will@onnyturf.com
#### URL: http://www.wjamesphoto.com/bw/bitweaver/
#### HOST: www.wjamesphoto.com
#### IP: 68.174.111.47
#### SQL: SELECT COUNT(mm.`msg_id`) FROM `messages`
mm INNER JOIN `messages_system_map` msm ON (mm.`msg_id`
= msm.`msg_id` AND msm.`is_read` <> 'y' AND `is_hidden`
<> 'y' AND msm.`to_user_id`= '2') WHERE mm.`to_user_id`
= 1 AND mm.`group_id` IN (SELECT `group_id` FROM
`users_groups_map` WHERE `user_id`= '2') LIMIT 1
#### ERROR CODE: Errno: 1064 Message: You have an
error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right
syntax to use near 'SELECT `group_id` FROM
`users_groups_map` WHERE `user_id`= '2')
}}}}}}}}}}}}} -> bit_error_string(Array[6])
}}}}}}}}}}}}} LINE: 636,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/BitDbAdodb.php
}}}}}}}}}}}} -> bit_error_handler(mysql,
EXECUTE, 1064, You have an error in your SQL syntax.
Check the manual that cor..., SELECT COUNT(mm.`msg_id`)
FROM `messages` mm INNER JOIN `message..., false,
Object:adodb_mysql)
}}}}}}}}}}}} LINE: 886,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/util/adodb/adodb.inc.php
}}}}}}}}}}} -> adodb_mysql::_execute(SELECT
COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN
`message...)
}}}}}}}}}}} LINE: 842,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/util/adodb/adodb.inc.php
}}}}}}}}}} ->
adodb_mysql::adodb_mysql::execute(SELECT
COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN
`message..., Array[3])
}}}}}}}}}} LINE: 487,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/util/adodb/drivers/adodb-mysql.inc.php
}}}}}}}}} ->
adodb_mysql::adodb_mysql::adodb_mysql::selectlimit(SELECT
COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN
`message..., 1, -1, Array[3])
}}}}}}}}} LINE: 251,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/BitDbAdodb.php
}}}}}}}} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::query(SELECT
COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN
`message..., Array[3], 1, null, -1)
}}}}}}}} LINE: 417,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/BitDbAdodb.php
}}}}}}} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::bitdbadodb::getone(SELECT
COUNT(mm.`msg_id`) FROM `messages` mm INNER JOIN
`message..., Array[3])
}}}}}}} LINE: 386,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/messages/messages_lib.php
}}}}}} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::bitdbadodb::messages::user_unread_messages(2)
}}}}}} LINE: 12,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/messages/bit_setup_inc.php
}}}}} LINE: 1080,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/BitSystem.php
}}}} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::bitdbadodb::messages::bitsystem::loadpackage(messages,
bit_setup_inc.php, true, true)
}}}} LINE: 1145,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/BitSystem.php
}}} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::bitdbadodb::messages::bitsystem::bitsystem::scanpackages(bit_setup_inc.php,
true, active, true, true)
}}} LINE: 147,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/setup_inc.php
}} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::bitdbadodb::messages::bitsystem::bitsystem::require_once(/home/wjames/wjamesphoto.com/html/bw/bitweaver/kernel/setup_inc....)
}} LINE: 9,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/bit_setup_inc.php
} ->
adodb_mysql::adodb_mysql::adodb_mysql::bitdbadodb::bitdbadodb::messages::bitsystem::bitsystem::require_once(/home/wjames/wjamesphoto.com/html/bw/bitweaver/bit_setup_inc.php)
} LINE: 23,
/home/wjames/wjamesphoto.com/html/bw/bitweaver/index.php