and btw we have to do just in one single page and thats " includes/db/connect_db.inc "  so there is no such issue of mysqli becoming mysqlii

what u means it would have become mysqlii ...

can u please help me

After using https://frontaccounting.com/punbb/viewtopic.php?pid=21291
Mysqli ...my table sorting by asc/desc  is not working

which is because of

function db_field_name($result, $n)
{
    //return mysql_field_name($result, $n);
       $fieldinfo = mysqli_fetch_field_direct($result, $n);
        return $fieldinfo->name;
    
    
}

and if i click on sorting asc or desc then

"//-----

DATABASE ERROR : Error browsing database: SELECT id,name,datetime FROM ".TB_PREF."test_table   ORDER BY ,  LIMIT 0, 10
error code : 1064
error 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 'LIMIT 0, 10' at line 1
sql that failed was : SELECT id,name,datetime FROM ".TB_PREF."test_table ORDER BY LIMIT 0, 10

---//"

see ORDER BY , 

i think field name is not coming here ...

and after long time i found the prb .. i dont know its in that function or not but when i replace all mysql to mysqli as per above code my asc desc stop working .. any idea ???

thanks

Please download a fresh installation from Sourceforge, and upload this to your server.

Make an install and see if you still have problems.

If so, something is not working correctly on your server.

Joe

Can u guide me how i can download mysql error log file and from where.

Also before move on.. can you please take my above code and test from your end .. also in some page i have used JOIN Query.

No i am not using Latest version . I think its 2.3.16 or 2.3.17

It would be difficult for me to Upgrade to latest version .. as i have modify many includes / files .. and some core file to.

If particular sort - db_page  file can be replace then please let me know which which file i need to replace for update.

But working fine @ my localhost

Please try to download the mysql error log file. If we are lucky we can probably see some errors here.

Are you running the latest release of FA? 2.3.21? If not try to upgrade as well.

Joe

and as said : SELECT VERSION()  , its showing me : " 5.5.36-cll "

please let me know

thanks

If you have access to the server phpMyAdmin, then open your database and in the SQL form, place the following:
SELECT VERSION() and run.

This will retrieve your MySql version.

/Joe

Thanks for reply.

Yes all folder are writable.

Also " no mysql runnung on the server ": if on my server there is no mysql running then how could i run all my statement till now.

still not able to sort

Joe

MySQL version >=4.1    Required        Upgrade MySQL server to version at least 4.1

means all is " OK " + green .. ONLY

MySQL version >=4.1    Required        Upgrade MySQL server to version at least 4.1   --- RED

AND SORTING IS STILL NOT WORKING

Thanks for reply .

Please find below link for system details : http://shashib.webege.com/system/