Support Analyst’s Talk

finish hp second round interview

3 days waiting for result

eAccelerator0.94 doesn’t competible with ioncube

installed 0.95

speed improved, but chinaeguide doesn’t display at all

check article on http://cmsreport.com/node/514     (Getting eAccelerator 0.9.5 to run correctly)

check where php error log is http://www.modwest.com/help/kb5-208.html

/home/.fromage/renbin/ionCube/ioncube_loader_lin_5.2.so
/usr/local/dh/apache/template/phpext/ZendExtensionManager.so
/usr/local/dh/apache/template/phpext/zend_optimizer4/ZendOptimizer.so

chinaeguide errors:

Notice: Undefined variable: hash in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 128

Notice: Undefined variable: cache_TTL in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 133

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/chinaeguide.com/httpdocs/index.php:128) in /var/www/vhosts/chinaeguide.com/httpdocs/includes/joomla.php on line 715

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/chinaeguide.com/httpdocs/index.php:128) in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 391

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/chinaeguide.com/httpdocs/index.php:128) in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 392

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/chinaeguide.com/httpdocs/index.php:128) in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 393

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/chinaeguide.com/httpdocs/index.php:128) in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 394

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/chinaeguide.com/httpdocs/index.php:128) in /var/www/vhosts/chinaeguide.com/httpdocs/index.php on line 395

Notice: Undefined offset: 18 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 18 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

Notice: Undefined offset: 1 in /var/www/vhosts/chinaeguide.com/httpdocs/modules/mod_ads_ticker.php on line 37

errorlog.php in forumdata does recorded mysql error. however it is not complete,

so I have to find mysql error log file and check what went wrong with the database.

also in backend of database, under system tools, it has system error record, which bring the details from errorlog.php.

the last error shows:

MySQL         07-5-30 10:24     forumdisplay.php : 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 ‘-3, 30′ at line 5 - SELECT t.*, p.rate FROM cdb_threads t LEFT JOIN cdb_posts p USING(tid, dateline) WHER …

so after sleep , I got to find check the details of each wrong query from mysql error log, though i don’t even know where the mysql error log is.