Oh my I hope I can get someone's help! I really messed something up!
(here is the confession)
I was working in the database and while in the Profiles table, I changed the auto_increment value to one that made more sense. Unfortunately after I did that, the value went back to what it was before the change, but it also messed up my join form. Whenever anybody tries to join it just returns a database error. I have tried restoring from an old database and nothing is working... AHHHHH....
This is one of the emails I am receiving, I want to thank you in advance for any help (I have hit panic mode, smile)...
Database error in Boston Erotic
Query:
SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
Mysql error:
Unknown column 'Couple' in 'where clause'
Found error in file /home/bostoner/public_html/mag/inc/design.inc.php
at line 1128. Called db_value function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/bostoner/public_html/mag/inc/db.inc.php
[line] => 115
[function] => db_res
[args] => Array
(
[0] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
[1] => 1
)
)
[2] => Array
(
[file] => /home/bostoner/public_html/mag/inc/db.inc.php
[line] => 133
[function] => db_arr
[args] => Array
(
[0] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
[1] => 1
)
)
[3] => Array
(
[file] => /home/bostoner/public_html/mag/inc/design.inc.php
[line] => 1128
[function] => db_value
[args] => Array
(
[0] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
)
)
[4] => Array
(
[file] => /home/bostoner/public_html/mag/inc/design.inc.php
[line] => 1228
[function] => getsitestatbody
[args] => Array
(
[0] => Array
(
[capt] => Members
[query] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
[link] => browse.php
[icon] => mbs.gif
)
)
)
[5] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 314
[function] => getsitestatuser
[args] => Array
(
)
)
[6] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 167
[function] => getblockcode_sitestats
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
[0] => 1
[1] =>
)
)
[7] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 132
[function] => genblock
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
[0] => 1
[1] => Array
(
[Func] => SiteStats
[Content] =>
[Caption] => _Site Stats
[Visible] => non,memb
[DesignBox] => 1
)
)
)
[8] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 78
[function] => gencolumn
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
[0] => 1
)
)
[9] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 105
[function] => gen
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/bostoner/public_html/mag/index.php
[line] => 75
[function] => getcode
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
)
)
)
Called script: /mag/index.php
Request parameters:
Array
(
[memberID] => 1
[memberPassword] =>************
[bblastvisit] => 1212208401
[bblastactivity] => 0
[adminID] => admin
[adminPassword] => *************
Query:
SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
Mysql error:
Unknown column 'Couple' in 'where clause'
Found error in file /home/bostoner/public_html/mag/inc/design.inc.php
at line 1128. Called db_value function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/bostoner/public_html/mag/inc/db.inc.php
[line] => 115
[function] => db_res
[args] => Array
(
[0] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
[1] => 1
)
)
[2] => Array
(
[file] => /home/bostoner/public_html/mag/inc/db.inc.php
[line] => 133
[function] => db_arr
[args] => Array
(
[0] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
[1] => 1
)
)
[3] => Array
(
[file] => /home/bostoner/public_html/mag/inc/design.inc.php
[line] => 1128
[function] => db_value
[args] => Array
(
[0] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
)
)
[4] => Array
(
[file] => /home/bostoner/public_html/mag/inc/design.inc.php
[line] => 1228
[function] => getsitestatbody
[args] => Array
(
[0] => Array
(
[capt] => Members
[query] => SELECT COUNT(`ID`) FROM `Profiles` WHERE `Status` = 'Active' AND (`Couple`='0' OR `Couple`>`ID`)
[link] => browse.php
[icon] => mbs.gif
)
)
)
[5] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 314
[function] => getsitestatuser
[args] => Array
(
)
)
[6] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 167
[function] => getblockcode_sitestats
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
[0] => 1
[1] =>
)
)
[7] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 132
[function] => genblock
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
[0] => 1
[1] => Array
(
[Func] => SiteStats
[Content] =>
[Caption] => _Site Stats
[Visible] => non,memb
[DesignBox] => 1
)
)
)
[8] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 78
[function] => gencolumn
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
[0] => 1
)
)
[9] => Array
(
[file] => /home/bostoner/public_html/mag/inc/classes/BxDolPageView.php
[line] => 105
[function] => gen
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/bostoner/public_html/mag/index.php
[line] => 75
[function] => getcode
[class] => bxtemplindexpageview
[type] => ->
[args] => Array
(
)
)
)
Called script: /mag/index.php
Request parameters:
Array
(
[memberID] => 1
[memberPassword] =>************
[bblastvisit] => 1212208401
[bblastactivity] => 0
[adminID] => admin
[adminPassword] => *************
[lang] => en
[strSec] => 7b83a8f48fd8c37727258549093375ad
)
--
Auto-report system
[strSec] => 7b83a8f48fd8c37727258549093375ad
)
--
Auto-report system
Ella
