Debug Message

array(2) {
  [0]=>
  string(155) "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 '[shop_id]' at line 1"
  [1]=>
  string(66) "SELECT * FROM shop_appearance WHERE shop_appearance_id = [shop_id]"
}
[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #1382 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetRow] #516 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getFirstRow] #1547 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #148 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3236 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #217 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #128 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php

Debug Message

array(2) {
  [0]=>
  string(155) "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 '[shop_id]' at line 1"
  [1]=>
  string(80) " select  count(*) from   shop_appearance  where   shop_appearance_id = [shop_id]"
}
[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #644 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getCount] #1572 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #148 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3236 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #217 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #128 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php

Debug Message

array(2) {
  [0]=>
  string(155) "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 '[shop_id]' at line 1"
  [1]=>
  string(80) " select  count(*) from   shop_appearance  where   shop_appearance_id = [shop_id]"
}
[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #663 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getCount] #1572 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #148 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3236 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #217 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #128 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php

Debug Message

array(2) {
  [0]=>
  string(155) "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 '[shop_id]' at line 4"
  [1]=>
  string(261) "SELECT `ua`.`city`, `ua`.`state`, `ua`.`country`
                    FROM `shop_appearance` as `shop` 
                    LEFT JOIN `users_address` as `ua` ON `ua`.`users_id` = `shop`.`users_id`
                    WHERE `shop`.`shop_appearance_id` = [shop_id]"
}
[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #1330 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetArray] #1197 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetAll] #588 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getAll] #1599 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #148 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3236 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #217 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #128 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php

Debug Message

array(2) {
  [0]=>
  string(155) "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 '[shop_id]' at line 5"
  [1]=>
  string(421) "SELECT *,DATE_FORMAT(date_of_join,'%M %d%, %Y') as date_of_join,u.users_id as users_id, sa.shop_appearance_id as shop_appearance_id
                    from shop_appearance sa,users u 
                    left join users_profile up on up.users_id = u.users_id
                    left join shop_banners sb on sb.user_id = u.users_id
                    where u.users_id = sa.users_id and sa.shop_appearance_id = [shop_id]"
}
[var_dumpa] #828 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[Execute] #1382 /var/www/html/jellyfiz/lib/adodb/adodb.inc.php
[GetRow] #516 /var/www/html/jellyfiz/framework/core/db/Db.class.php
[getFirstRow] #534 /var/www/html/jellyfiz/includes/common_functions.inc.php
[getShopDetail] #1611 /var/www/html/jellyfiz/modules/product/usershop.php
[load] #148 /var/www/html/jellyfiz/modules/product/usershop.php
[run] #3236 /var/www/html/jellyfiz/modules/product/usershop.php
[include] #217 /var/www/html/jellyfiz/includes/app.class.php
[_load_module] #128 /var/www/html/jellyfiz/includes/app.class.php
[run] #12 /var/www/html/jellyfiz/index.php