Admin section different charset - Page 2

Chuck S · May 29th, 2007, 10:56 AM

Nope regular MYSQL so it seems as long as one loads the right charset we support UTF fine.

Your issue is probally with MYSQLi and given we clearly do not list our program supports that then you might want to try that mod you noted but this is outside our program support

tomzl · May 29th, 2007, 11:10 AM

vBulletin only works with utf-8 when you use MySQLi otherwise the AJAX elements cause problems. So Classifieds are not compatible with vBulletin when you use utf-8 properly?

Since when is MySQLi not a MySQL database?

You gave a different answer in this thread about MySQLi...
Is PHP 5.x.x ok for PhotoPost?

What is needed to make Classifieds MySQLi compatible?

Chuck S · May 29th, 2007, 11:17 AM

You can try using that hack to replace all calls with mysqli if you want but as I stated that is beyond what we support.

I have clearly shown we support UTF as shown here I am using your own user title as an example

http://www.reeftalk.com/classifieds/...php?product=26

Your issue is with using mysqli for vb and things seem to be stored different so they will be displayed different. If your vb was using mysql not mysqli it would display right just like my test site

Most programs tell you specifically if they support mysql or mysqli and I know vb tells you that. No where on your site do we state we support the mysqli extention

I have not looked at whats involved but I beleive you need to change all mysql connect strings etc from examples below

mysql_num_rows

to say

mysqli_num_rows

There might be more to it but you would need to look at that hack you noted and see

tomzl · May 29th, 2007, 11:53 AM

Actually vBulletin doesn't mention specifically it supports MySQLi. It simply states MySQL as opposed to MSSQL which is logical since MySQLi is just a feature for PHP 4.1+ Since they figured out that their program does not work with utf-8 unless MySQLi is selected, they added an option for this. The same should happen with your program.

Your site should say, if there are limitations. Obviously your program is not compatible with all vBulletin forums and all PHP versions.

It is missleading to potential customers who have no way to test the software before buying (demo was removed). If you indeed do not support MySQLi, it is even more strange that the script which tests the server compatiblity did not report an error before my installation and that you yourself tell other users before their purchase it is OK to use it for your program.

From my point of view I paid a lot of money for something that doesn't work eventhough it is advertised otherwise. How am I supposed to know if the software will work for me or not beforehand? You yourself admitted the webpage is out of date and rarely updated. It still says Classifieds 2.0 are the latest version...

I am not an expert in PHP so how should I know how to modify the code? I doubt it is as easy as just adding an "i" to change the code to mysqli. If I were a programmer, I wouldn't buy your software in the first place since I could write it myself. Pointing me to the mods section is a simple way to let me deal with the problem myself since there is little activity in the mods section. Most users are left to themselves.

What do you suggest to resolve this matter?

Chuck S · May 29th, 2007, 12:02 PM

Our site states it works with mysql not the extention mysqli and writing the application to support mysqli is outside the program support as we support it as it is written. Our program also states the only support language is english right on our site.

This is why you are left to the mod section for several reasons. I am glad to help if there is something simple I can post to make it work outside the parameters it is designed for.

I looked at that users hack and although its hard to read cause its a diff file it only looks like to me he went through the entire program and changed the calls from

mysql_

to

mysqli_

I can not tell you what more is involved but that is where you can begin if you choose to do this.

My test example clearly shows we support the utf language encoding should both databases be of the same type and scripts using the same. The issue you have is they are using different backend types of mysql extentions.

tomzl · May 29th, 2007, 12:15 PM

Do I need to do anything else aside from deleting the tables and the files to uninstall Classifieds?

Chuck S · May 29th, 2007, 12:36 PM

No you do not. Deleting an install is simply deleting files and the database tables

Chuck S · May 29th, 2007, 12:47 PM

I also did another test to see if we show UTF right in the program and used both the username and usertitle you specified

http://www.reeftalk.com/classifieds/...7/limit/recent

So this issue seems localized into using different database encodings between programs

tomzl · May 29th, 2007, 01:09 PM

I tried using the convertor tool provided by MySQL to change MySQL calls to MySQLi calls but it still does not show correct characters. I tried entering a new ad and still the same problem. Some calls could not be converted. Any chance you could take a look at it? Most files get converted fine but some have warnings, some about potential security bugs...

http://forge.mysql.com/wiki/Converting_to_MySQLi

I'll try a clean install next but it appears even with MySQLi calls the problem remains.

Chuck S · May 29th, 2007, 04:14 PM

We do not support the use of mysqli within our application. I can not offer any assistance hacking the scripts

In a normal vb classifieds install where they both are installed as mysql not mysqli extention we seem to display the UTF fine as I have shown in my explicit example

http://www.reeftalk.com/classifieds/...7/limit/recent

I have stated if you wish to hack your scripts to attempt to use mysqli you can do so as a mod but we do not support that.

tomzl · May 29th, 2007, 05:48 PM

Can you at least tell me which files are used to fetch information from the vBulletin tables? From what I understand I only need to edit those files which get information from vBulletin since those are causing problems.

Chuck S · May 29th, 2007, 05:51 PM

The functions to get vb info are in the vb3.php file and the specific function is get_profiledata

tomzl · May 29th, 2007, 07:07 PM

Unfortunately none of this worked. I will try to get some help from my server admin tomorrow but I doubt he can help either.

Since I cannot get the program to work, I'd like to at least get my money back. Surely I couldn't have predicted that the program will not work.

I noticed you also offer an Advanced installation service and under the requirements it only says PHP and MySQL must be installed (no mention of MySQLi). If they are installed, the service is guaranteed or installation and licence fees are returned. The same should apply in this case then. Even if you had installed it, it wouldn't work properly.

http://techimo.stores.yahoo.net/imadin1.html

I also noticed you offer Custom programming services. How much would it cost for you to adapt the software to work with MySQLi, if possible? Rough estimate?

I'm trying to find a way to make Classifieds work somehow...

Chuck S · May 29th, 2007, 08:00 PM

No an install guarantee would not apply since we are talking mysqli engine not straight mysql. We have clearly shown UTF works fine and displays fine within our application. I typed UTF in a username, ad description and a users title all display fine. The program is working completely fine from all testing I have done. Install a test copy of vbulletin with mysql extention not mysqli and do the same test I have done you see UTF works fine. I clearly showed it worked by the link to the test on my site

http://www.reeftalk.com/classifieds/...7/limit/recent

I personally can not test out mysqli as my host does not have it installed correctly.

If you really want to test out things I suggest you install a test forum using mysql and integrate classifieds with that and see that things work out fine as I have posted

tomzl · June 1st, 2007, 08:04 AM

I installed Classifieds in a separate MySQL database and noticed that categories with special characters are displayed incorrectly in the admin panel when utf-8 is selected but show up correct on the main page.

Does this have anything to do with the other problems I've been writing about? Can the same problem that causes characters to be wrongly displayed in the admin panel be to blame for the wrongly displayed usernames and user titles from vBulletin?

It seems in this case Classifieds don't know how to interpret data they enter into the database themselves...

Chuck S · June 1st, 2007, 09:14 AM

That has to do with the fact you need to edit your admin file and place a utf meta charset in there cause if your using english.php that file is loading the regular charset not utf

As I have clearly outlined I have vbulletin and classifieds set to utf charset and test your issues and there are none

http://www.reeftalk.com/classifieds/...7/limit/recent

Your issue has to do with mysqli which we do not use which means the information is stored is some other format and since we dont use mysqli it is not displaying correct. I have asked several times how that data meaning username or rank is stored in your vb database and you have not answered.

I can not assist if you dont post responses.

tomzl · June 1st, 2007, 09:58 AM

Quote:

Originally Posted by Chuck S

I have asked several times how that data meaning username or rank is stored in your vb database and you have not answered.

Look at post #19 in this topic. I have written exactly how the data is entered into the database for both Classifieds and vBulletin.

tomzl · June 1st, 2007, 10:03 AM

Quote:

Originally Posted by Chuck S

That has to do with the fact you need to edit your admin file and place a utf meta charset in there cause if your using english.php that file is loading the regular charset not utf

Which admin file do I have to edit? I already entered utf-8 into the admin-inc.php and english.php as well as all other files that mention charset tags.

Chuck S · June 1st, 2007, 10:49 AM

I have not asked multiple times here how your entering it I have asked how it is stored in the database which means you need to post how that is stored in both databases

tomzl · June 1st, 2007, 01:35 PM

Quote:

Originally Posted by Chuck S

I have not asked multiple times here how your entering it I have asked how it is stored in the database which means you need to post how that is stored in both databases

That is exactly what I have done in post #19. I wrote how the text is entered (stored) in the database. Obviously I enter it the same way each time but you can see from post #19 that it is stored differently in each table. vBulletin stores the same characters differently than Classifieds.