| Author |
 Topic  |
|
zakazn
New Member
58 Posts |
 Posted - 25 February 2010 : 13:54:37
|
Or if that doesn't work,here's a text file
link removed |
Edited by - zakazn on 26 February 2010 04:25:13 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 February 2010 : 14:03:47
|
Ok, I changed your script so that you use MyISAM tables and latin1 as charset. Not sure it will fix it, but it can be tried.
You can get the changed file here.
Rename it to .sql, drop your existing tables or the database itself and run the script using phpmyadmin or whatever tool your are using. It will create the tables and populate them. See if this sorts the problem.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zakazn
New Member
58 Posts |
Posted - 25 February 2010 : 14:16:45
|
I dropped the existing tables and tried populating the tables but get this error!
External process terminated abnormally. Exit value: 1
Output stream to process closed abnormally.
Error: ERROR 1253 (42000) at line 19: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'latin1'
I ran the original SQL file and this populated the tables without a problem |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 February 2010 : 14:30:55
|
| I am suspecting the problem is that utf8_bin. Seems the database needs to created with a matching collation too. Do you have permission to create a database on that server? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zakazn
New Member
58 Posts |
Posted - 25 February 2010 : 14:45:17
|
| I must have permission because I deleted the database and added another (which populated from the original sql file). It was just the problem with the amended version. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 February 2010 : 14:51:44
|
You can try running this then:
CREATE DATABASE ChooseDBName DEFAULT CHARACTER SET latin1 DEFAULT collate latin1_general_ci
The run the script on this database and see if the forum works.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zakazn
New Member
58 Posts |
Posted - 25 February 2010 : 14:58:42
|
I tried that, it let me create the database, but then when I tried to load the SQL I got this error again:-
External process terminated abnormally. Exit value: 1
Output stream to process closed abnormally.
Error: ERROR 1253 (42000) at line 19: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'latin1' |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
zakazn
New Member
58 Posts |
Posted - 25 February 2010 : 15:07:08
|
Hmm, I deleted the database and then created the new one running the script above, but I used the same database name as previously?
I have tried running the script again with a different database name and get this error
Error message from server:
Access denied for user 'bromley'@'%' to database 'DBName'
So I guess I don't have rights to create a new database? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 February 2010 : 15:14:05
|
That would indicate a permissions issue.
You can try running this:
GRANT ALL PRIVILEGES ON DBName.* TO bromley@'%' IDENTIFIED BY 'YourPassword';
If it works, you will then have the required permissions. Try it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zakazn
New Member
58 Posts |
Posted - 25 February 2010 : 15:19:20
|
I tried this and got error message:-
Error message from server:
Access denied for user 'bromley'@'%' to database 'DBName' |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 February 2010 : 15:26:21
|
| Seems you need to get your MySQL server admin to give you permissions on the database you have just created. It's essential that you try a database created with the latin1_general_ci collation, not the default server settings. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
zakazn
New Member
58 Posts |
Posted - 25 February 2010 : 15:27:21
|
| OK, I'll ask them to do that - will be tomorrow now. Is there anything specific I need to ask them? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 February 2010 : 15:29:29
|
Generally you can ask them to create database with the collation I told you and assign permissions so that you can access it from your webserver. Once you get that, run that script I linked earlier.
I hope this will be it. I can't think of anything else that could be causing this and never experienced it myself. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
j0nTayl0r
Starting Member
United Kingdom
1 Posts |
Posted - 26 February 2010 : 04:05:41
|
Hi,
[I admin the server in question]
Although I changed the database to use latin1 this in itself didn't fix it.
I've also used the web.config to set a locale of en-GB and file encoding of iso-8859-1, the request/response encoding is still our default of utf-8.
I then did a new install of the forum (keeping the config and database).
This looks like it's solved it. The ASP errors have gone and the messages are not being converted to "?".
Not sure whether it was the web config or the re-install that fixed it.
Thanks for the advice.
Cheers,
Jon |
|
|
|
Topic |
|
Topic Locked
