Joomla 1.5.14 errors - maybe database problems - Joomla! Forum - community, help and support

hello everyone!

i have been using joomla time , find useful needs.
although worked months without problems, these days started giving me errors.

first hand, started logging me off administrator panel when working in (like known joomla 1.x problem) , making admin panel pretty unuseful.
having problem enabled debug log in admin panel can see problem , got 19 queries logged:

code: select all

19 queries logged.

   1.
      select *
        jos_session
        session_id = '69f1ce8a08b126a2b34cd5a7e17a1305'
   2.
      delete
        jos_session
        ( time < '1255950557' )
   3.
      select *
        jos_session
        session_id = '69f1ce8a08b126a2b34cd5a7e17a1305'
   4.
      update `jos_session`
        set `time`='1255951457',`userid`='62',`usertype`='super administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='orvafzeviqfc2nrvulrjnisg1nbbofgzyqy3qxzoqxi4bayu7n_e2fjpzuq5vlqeku9ccew4xj_txdsnxxji1i-nbtqw0yr7htgeodbwau4wg73fb74tmhlqzwrv7dlpslf_ozc995hvamjn_aw0xgcn9k-nvvmy5gonpqccb0mi8wlsq6_f2fnziiyzphyoneak2401xqx7qukqd8ilxq1basa_n-xjatlfa-bermwi4gdsfb4y2lhg8bd-3hkbj09owpmfdi3fberyv7do2au9bf84cyqbuvr8f7hyjlafuw3kcqixto16qmcakimebyeaufchmftc17hggm2zzdypjt-xkiepcrbm8-ddqpaxmyoqqebdtvv23rng7vl-yafhg3epppqtr744hiq33rpeoe93ugzacfcswdautc8onkh2euxybxogh9cilbbx3dkbtskomvp56y7lyerhq3vuiy90dihiugdjtmqcblllkax70f5axb-liryt_ukbautarlwt4g2oyioxrmevhtceqyor2am8mao0_talfuaxg6vse54ris2fqklkqqpjpocqumb2omq2hfsmkkeas4pukptag2gek0o3p-srqjw9s4xkggcmuuz8q1yelzvv6jy9zq86t9ojgncoxwqhvhdswr9lrukdg_kc-pt5zmbqqhsh1bei0nqt7sxwbl9d7qkphgmwccxnsywashqzlrhyiplgkjowy7amaol87a0p9hfta3r3ikktofgfilgv07dkcyy5xt76vllkz6duambant69z-jdumrzwqglzheryjd-1itww-w0mjkbjvgyi15ypyw_8wsagt3bo_n96qcq_ctxmikpue9dmejlwpvm0q15u0q3nuqzhi-cjnuaokwtvg0yajztxwblotak2bu21_ggijx5bqecvlkwac4avqdqgbrfwi6yb8yfgzuf0po3frg1cd3r4p2qkjhuzxu2soq2jfckhfcor4l1qjpyavjnxvsiozq3vxbulryb1rer1hdsid19kmsrtd22iobpadhmr7vhplknwf8xer3unx8piqcz-sm2tsium-0h_dimlbuz9jlx2uet6gmyv9wbjgpy1j2fxos-lmroyit4jyozghkveofy8_xqkcstyiyt-acpe2uuolxckuzwcl7jkyoqy62a-ggarhxw6cutlpbssxz9zqwr-ops7oqkfqhgukcip9vtw3v4yxvexmagy11vsqggvnrcvv2_j5ymeen98vcwsjmir6qc54opljoaf8o9skavjuhcnoqhq49ncom4ngcrorxnygvtvq6zjla-zmfzamoicn9hi8ivqvz6bjunncw458uwzqliwvbruxoipobyttkc_vi2xvnngk6_rgd3z56w5esqhfboram7i0wzw8hp-hpnw0ihcwdby7zo_hnjshpzdtj05ayxq5xbcdhonhyjin4hmdptkvfcjv3soqngi45o2sxk3ccv9c3w3hdgseg0-vjfzixhpudd-yb5esumfcs3pki4ywgzi3uldp6j5isfsswqzlj0nbyfqm2sojiza6hmsx1za3ofs29x9kgfqnhjezmt_n2dyydhzmyeiw831ewtzrguk7jv4iq4bc-iqjxclgorpf9hmi68m-x3bzlhuz9pmqrt9tyhrt_nlrck3qhltkz1obhjfxmg8yk1ez-4zpnhfsqmqtn11otnrglirxm59gk-didqn7k2andlejhl6jtnp3pfupsssnmiryg0phhlo_hli5pl3fvyxa3me3fmmchvsmysdgkw6xml8xjn-uamgvwdiqlrhbaana4v64_oiqpp2zntt-vbxh6tv2vw1du7ylzynckwnb_kiuphvlorsartir_zxxt4fe6ay84wcc5hdjxq-xlwfgxiwjakajagvtatzlxblq5wdfxe0obwrx-pzisd62rkufaxiicmwdgnnuspdcfur3s7jv3nyj3byu0mtsy1ylvekcngus7oiqmoql9n9afqcmlk6_mfd1o1cvjc5ndyu_r84tlnh9ka3nntpcszgwpzgxcekfcwebqlfoukx1bsyspurwicfusoxhr_9fe-1iyxgtaac9yxtyzolbek_y0suizpba..'
        session_id='69f1ce8a08b126a2b34cd5a7e17a1305'
   5.
      select *
        jos_components
        parent = 0
   6.
      select folder type, element name, params
        jos_plugins
        published >= 1
        , access <= 2
        order ordering
   7.
      select id, title, module, position, content, showtitle, control, params
        jos_modules m
        left join jos_modules_menu mm
        on mm.moduleid = m.id
        m.published = 1
        , m.access <= 2
        , m.client_id = 1
        order position, ordering
   8.
      select template
        jos_templates_menu
        client_id = 1
        , menuid = 0
   9.
      select count(*)
        jos_session
        userid != 0
        order usertype, username
  10.
      select username, time, userid, usertype, client_id
        jos_session
        userid != 0
        order usertype, username
  11.
      select a.hits, a.id, a.sectionid, a.title, a.created, u.name
        jos_content a
        left join jos_users u
        on u.id=a.created_by
        a.state <> -2
        order hits desc
        limit 0, 10
  12.
      select a.id, a.sectionid, a.title, a.created, a.modified, u.name, a.created_by_alias, a.created_by
        jos_content a
        left join jos_users u
        on u.id = a.created_by
        a.state <> -2
        order created desc
        limit 0, 10
  13.
      select menutype, count(id) numitems
        jos_menu
        published = 1
        group menutype
  14.
      select a.*, sum(b.home) home
        jos_menu_types a
        left join jos_menu b
        on b.menutype = a.menutype
        group a.id
  15.
      select *
        jos_components
        `option` <> "com_frontpage"
        , `option` <> "com_media"
        , enabled = 1
        order ordering, name
  16.
      select joomlatablename,tablepkid
        `jos_jf_tableinfo`
  17.
      select *
        jos_languages
        order ordering
  18.
      select count(*)
        jos_messages
        state = 0
        , user_id_to = 62
  19.
      select count( session_id )
        jos_session
        guest <> 1

i don't know understand logs because i'm beginner in php.
after errors, today, have seen main page isn't working , it's giving me following error:

code: select all

500 - jdatabasemysql::query: 1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'and jf_content.reference_id in(20,44,45,51,28,46,52,24,47,59,60,29,53,1,54,50,55' @ line 4 sql=select jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value jos_jf_content jf_content jf_content.language_id= , jf_content.reference_id in(20,44,45,51,28,46,52,24,47,59,60,29,53,1,54,50,55,57,61,63,66,64,65,18,30,67,68,69,70) , jf_content.reference_table='menu'

code: select all

call stack
#    function    location
1    jsite->render()    xxxxxxxxxxxxxx/index.php:79
2    jdocumenthtml->render()    xxxxxxxxxx/includes/application.php:168
3    jdocumenthtml->_parsetemplate()    xxxxxxxx/libraries/joomla/document/html/html.php:249
4    jdocumenthtml->getbuffer()    xxxxxxxxxx/libraries/joomla/document/html/html.php:386
5    jdocumentrenderermodules->render()    xxxxxxxxxxx/libraries/joomla/document/html/html.php:190
6    jdocumentrenderermodule->render()    xxxxxxxxx/libraries/joomla/document/html/renderer/modules.php:41
7    jmodulehelper->rendermodule()    xxxxxxxxxxx/libraries/joomla/document/html/renderer/module.php:84
8    require()    xxxxxxxxxxx/libraries/joomla/application/module/helper.php:173
9    require()    xxxxxxxxxxxxxx/modules/mod_jflanguageselection/mod_jflanguageselection.php:84
10    jfmodulehtml->_createhref()    xxxxxxxxxxxxx/modules/mod_jflanguageselection/tmpl/rawimages.php:47
11    jfmodulehtml->_createhref2()    xxxxxxxxxxxx/modules/mod_jflanguageselection/helper.php:141
12    jfmodulehtml->getjfmenu()    xxxxxxxxxxxx/modules/mod_jflanguageselection/helper.php:164
13    jfdatabase->loadobjectlist()    xxxxxxxxxx/modules/mod_jflanguageselection/helper.php:255
14    joomfish->translatelist()    xxxxxxxxxxxxx/plugins/system/jfdatabase/jfdatabase_inherit.php:371
15    joomfish->translatelistwithids()    xxxxxxxxxxx/components/com_joomfish/helpers/joomfish.class.php:181
16    jfdatabase->loadobjectlist()    xxxxxxxxxx/components/com_joomfish/helpers/joomfish.class.php:274
17    jdatabasemysql->loadobjectlist()    xxxxxxxxxxxx/plugins/system/jfdatabase/jfdatabase_inherit.php:319
18    jfdatabase->query()    xxxxxxxxxxxxxx/libraries/joomla/database/database/mysql.php:458
19    jdatabasemysql->query()    xxxxxxxxxxxxxx/plugins/system/jfdatabase/jfdatabase_inherit.php:641
20    jerror->raiseerror()    xxxxxxxxxxxxx/libraries/joomla/database/database/mysql.php:231
21    jerror->raise()    xxxxxxxxxxx/libraries/joomla/error/error.php:171
22    jexception->__construct()    xxxxxxx/libraries/joomla/error/error.php:136

the site uploaded on free webhost , worked fine quite time. problem occur hosting service?

i appreciate if give me , answer problem or tell me whats going on.

p.s: upgrading 1.5.14 make difference?

thanks.

jrbad wrote:p.s: upgrading 1.5.14 make difference?

i doubt many waste time helping until upgrade. using outdated version when many security releases have been out there long makes no sense.