Weird Characters MySQL
May 5, 2009I keep getting weird characters such as .... in MySQL.
View 3 Replies
ADVERTISEMENT
Weird Characters
Mar 29, 2008I'm seeing weird characters on my support home page:
That's found right below "Home > Support"
The source code shows the following...
Quote:
<tr>
<td style="padding:0px"><p>Welcome to our Support Area.</p>
I've checked the two template files (header.tpl and homepage.tpl) but did not find such characters. Its boggling me. Not even whitespace.
Weird Characters When Trying To Retrieve From A Backup
Jun 9, 2008I'm trying to retrieve some files from another hard disk and I get weird characters.. Exemple:
("location:index.php"); becomes ("lOcation:aNdex.php");
MySQL :: 16 Characters Limitation About A Username Length
Apr 27, 2009I am unable to create a user in mysql with 20 characters length. I am getting the annoying error message about 16 characters limitation about a username length. I have tried to increase the character user limit length to 32 characters using the following commands:
mysql -uroot -p
use mysql;
alter table `user` modify `User` CHAR(32);
FLUSH PRIVILEGES;
quit
service mysqld restart
But after all of this was done I was and I am still unable to connect to mysql anymore with/without password.
Mysql On The Dbserver Is Up And Down.. Weird
Apr 15, 2007This morning my db server is acting weird.
sometime the query can go thru to the dbserver, but after refreshing 2-3 times i get mysql connect error.
any idea what is the problem, here's the link:
[url]
i dont know what to do... already restart the mysqld , reboot the server...
Weird MySQL: User/pass Stops Working After A While
Mar 29, 2009I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each.
Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem.
Also on the server we have Fantastico.
Arabic Characters
Mar 15, 2008Someone reported invalid arabic characters in webmail (squirremail precisely)
How can I correct this on a cpanel box?
Characters Displayed
Sep 12, 2007I have an oddball problem here that I haven't seen.
When you visit domain.com, characters are displayed like the files are not being properly read. However, when you visit domain.com/index.php all works fine. I thought this would be an .htaccess issue and tried simply removing it, but this doesn't fix the issue. I checked httpd.conf and all looks fine there too.
Accented Characters With Apache
Jan 7, 2008Recently we have moved our Invision Power board (version 2.3.3) from InvisionPower hosting to a dedicated server. On our new server we have:
Apache 2.2.6
PHP 5.2.4
MySQL 5.0.24
Things seem to be about 95% OK, however, there are occasional problems with posting: several members tried to post Hungarian and French characters, like
Á Í Ő Ö Ő Ű
à â ç é è ê ë î ï ô û ù ü ÿ
These are not getting through, and they get an error:
Bad Request
Your browser sent a request that this server could not understand.
Apache/2.2.0 (Fedora) Server at Port 80
Members have been asked to try with Explorer, Firefox and Opera, and all get the same results. This is strange, as most Croatian and Serbian characters that are accentuated, like:
č, š, ć, ž
These go through just fine, as well as Cyrillic alphabet is OK as well.
Additionaly, one member reported a problem that 3-4 times he got an error while posting (but is usually OK to post), and he writes in Serbian Cyrillic - which seems to be usually fine, but there is an odd problem and error message:
Method Not Implemented
POST to /forums/index.php not supported.
Apache/2.2.0 (Fedora) Server at Port 80
We asked Invision Power Board tech support, however they say that the errors are on the server end in the Apache configuration, and not IPB. Which seems logical, as before the move on the new server (I don't think the old server used to run Apache), nothing like this used to happen.
Strange Characters After Migration
Nov 18, 2008after i move this accounts from old server to new server it shows me confused characters . ...
View 12 Replies View RelatedIllegal Characters In Php Pages
Aug 30, 2007I have a cpanel 11 server with php 4.4.6 installed. my site use php scripts and one day even if the file was not edited, not touched at all , i get errors like
Parse error: syntax error, unexpected ']' in /home/xxx/public_html/wp-includes/post.php on line 37
I checked and could find a lot of illeagal characters in my php file. See below. for post_status , it became post_statuó and edit_date became edit_date<8d>. If you read through the code, you can see a lot of illegal characters. This is why i get parse errors. I had to replace the file from backup and the issue fixed. But this problem continues to occur for more files and i can't find a reason for this. Again I am the only one with access, I use BBedit to edit php files when needed in Mac OS X, and beleive I know what is being edited and again, those file which gets errors does not need to be edited for nothing, not even to modify wordpress.
======================================================
iN ( 'draft' == $post['post_statuó'] && empty($postarr['edit_date<8d>]) && empty($postarr['post_date¯]) &&
('0000-00-00 00:00:00' == $post['post_date']) )
$clçar_date = true;
else
$clear_nate = false;
// Merge old and"new fields with new fields overÃriting old ones.
$postarr = arRay_merge($post, $postarr);
$poytarr['post_category'] = $post_cáts;
if ( $clear_date ) {
$poótarr['post_date'] = '';
$postërr['post_date_gmt'] = '';
}
éf ($postarr['post_type'] == 'at|achment')
return wp_insert_atÃachment($postarr);
======================================================
PHP/DNS/Excessive Null Characters Error?
Apr 5, 2007I'm having a problem that I've never run across before, and was wondering if anyone might have any ideas as to what may be causing this.
Basically, on 3 of 5 new servers on a brand new private rack from The Planet, we're having what we've narrowed down to be a problem with PHP or Apache. Loading any sort of PHP page with a larger output (even such as a simple 'phpinfo' call) results in, depending on the computer or browser in use:
- The page loading for a split second then reverting to a DNS Server Not Found page (observed in IE)
- The page loading, but filling the source code with vast amounts of extra blank spaces, making a simple phpinfo call download 5+mb of HTML (observed in both IE and Firefox)
- The page loading part way, then hanging (observed in Firefox)
- Occasionally the page will reload over and over again all by itself until it ultimately goes to a DNS error page (observed in IE)
Pages not including PHP, including very long .HTML and .SHTML pages, load just fine.
Here's a link to a page calling a simple phpinfo string, and nothing else (as this is my first post, I can't link directly to URLs, sorry):
IIS Email Server Dropping Characters
Jan 30, 2007after putting up a very simple email program and having it email me a set of text, it looks like it is not a software problem, but something to do with the IIS email server. Has any one ran into this?
View 1 Replies View RelatedApache :: Characters In URL But Not In Query String
Feb 21, 2013I have an [URL] ....
I use htaccess to rewrite it to: [URL] ...
and there is a problem, because I do not get what I need. The result is: [URL] .....
The last / sing dous not even matter, because if I write the url without the ending /, the three dots are still removed.
It looks like everywhere in the url the (in regexp) .+/ pattern is replaced with a simple / sign.
The RewriteRule is very simple, I can not imagine it has anything to do with this, but it looks this:
RewriteRule ^(.*)$ index.php?p=$1 [QSA]
I started to log the rewrite and it looks like if the specific parts of the url are replaced before the rewrite got it.
These are the first few rows of the rewrite log:
add path info postfix: E:/web/service/szerz....odes -> E:/web/service/szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/
strip per-dir prefix: E:/web/service/szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/ -> szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/
applying pattern '^(.*)$' to uri 'szerz....odes/action/axgetszerzodesar/ugyfelid/46402/termekid/46032/szerzodesszam/2012.01.01/'
webserver: Apache/2.2.22 (Win32) PHP/5.2.17
and Apache/2.2.9 (Win32) PHP/5.2.17 (I refreshed it today because of this problem)
os: win7 home premium sp1
It is tested on a linux os too, but there were no such problems.
SSH Commands - Deleting Files And Escaping Characters
Jun 26, 2008I have two quick questions.
Question 1
I had a script create a backup of every file on my site using the following format "filename.php.bac". I want to delete these files now and I tired to use "rm *.bac" but that only deleted the files in the current directory. How can I delete ALL those files in EVERY directory and sub-directory starting at the public_html directory?
Question 2
How can I escape semi-colon's (;) in a perl script? I'm trying to run a search+replace script to update some Analytics code and I have a ton of files to update but for some reason if there is a semi-colon in the find varable, it assumes that it has reached the end of the contents in that variable.
Here is the code. Take a look at the $find variable and you will see extra semi-colon's. How do I tell the script to not treat those semi-colons as the end of the variable? .........
Using Spamassassin: How To Block Japanese, Chinese, Etc. Characters
Apr 1, 2007is it possible to configure so, that it would be possible to receive only in Latin and Cyrillica written mails? No Chinese, Japanese, etc. characters, I mean.
View 0 Replies View RelatedApache :: Redirect Matching First Characters Of URL Using HTAccess
Jun 12, 2013I want to redirect all the URLs starting from specific characters.
For instance:
www.example.com/abc-apple
www.example.com/abc-bat.html
www.example.com/abc-cat.php
All of the URLs above starts with "abc-" I want a redirect code to redirect all URLs starting from "abc-" to a single URL i.e. www.example.com/allÂ
Apache :: Access Forbidden If URL Contains Special Characters
Jun 3, 2013We have many intranet document what linked on our intranet site. We use "apache builed in" directory listing to handle documents on browser, and make accessable to users. Because this not so user friendly we try to use a template (h5ai-[URL] ....) for mod_autoindex.
Unfortunatelly if file or folder name contains special characters (like é,á,ű,ő,ú,ü,ö,ó) than get Access Forbidden - Error 403. If change the folder name, than its ok.
I use xampp. how to solve this.
Apache :: Get Parameters With Cyrillic Characters In URL String Are Not Visible
Oct 30, 2014I've migrated from Apache 2.2 to Apache 2.4 few days ago. It is installed as a service on my Windows 7 developer machine and works in bundle with PHP 5.6.2.
Today I've discovered that GET parameters with Cyrillic characters in URL string are empty.
For example URL looks like this: site.com/search.php?q=%C8%E2%E0%ED%EE%E2
URL-encoded string here is Иванов (%C8%E2%E0%ED%EE%E2)
When I try to use this GET parameter in my PHP script - the variable $_GET['q'] is empty. If I put latin characters in this parameter - $_GET['q'] is taking the corresponding value.
Doesn't look like it's a problem of PHP as I think. Otherwise at least something should stay in the variable. And also I would like to add that this was working absolutely normal on Apache 2.2.
Weird RSS Feed
Jun 3, 2009I've got a vB site which has a RSS Poster Bot (fetches RSS Feeds then posts them). However, for some strange reason, it stopped working. Theres no errors in the error_log and when I do a manual run, it just times out after a minute or so.
The only thing I can think of is that one of the RSS Feeds is down or one of the sites is blocking the server IP for some reason.
Weird Spamd
Apr 28, 2008i have this really annoying issue i'm hoping you can help with.
it seems the spamd child process gets stuck and causes 100% cpu usage. but this doens't just happen randomly, its only for this single user account. e.g. take a look at top output:
4581 <username> 93 40:58.87 1.3 82624 52m 2280 R spamd child
the 93 is 93% cpu usage. 40:58 is how long the process has been running, 40 minutes and counting (i just killed it though). and all it tells me its running spamd child. it usually dies after a few hours but only after causing 200% cpu usage (100% on both cpus) and making my server load skyrocket. This happens at least twice daily at no set times.
this user isn't a spammer. no scripts, no mail queue generation, no email accounts even.
running cpanel 11, centos 4.
Weird Bind
Oct 8, 2007I have a weird problem since the movement of our ip range with one of our servers. Bind doesn`t seem to react on any changes we make.
For example, the server still resolves to the old ip adress while we changed all of those with ipswap.sh (directadmin)
The weird thing is that all zone files are 100% Correct. Ip`s are all changed and no sign of the old ip whatsoever.
Again, the nameserver still resolves to the old ip`s.
Also when i create a new domain, named.conf is changed and the zone file is created sucessfully. Still the nameserver doesn`t seem to add the domain name.
Restarting, reloading and even reinstalling named doesn`t help
Weird Vsftp/ftp
Aug 4, 2007Got a couple of questions on my Centos server.
It is my only (at present), and main production web server located in a datacentre in the Uk.
I am running Centos 4-4.2 since a hardware failure earlier this year neccesitated a stressful overnight ssh reinstall.
I have it setup pretty well now (I think!) but I cant work out how I am able to sftp into the server!
Reason being, I have installed VSFTPD (made sure there were no ftpd daemons installed or running), and when I stop this service via sshd, it does not affect the fact that I can then sftp in to the server using an ftp client such as wsftp pro...
Also, even when I change the vsftpd.conf to jail certain ftp users to a directory, it seems to have no effect and ftp works exactly as it did before without imposing the restrictions?
There is no other ftp daemon showing up in the process list.
I have tripwire installed, rootkit hunter, and cisco hardware firewall in conjunciton with ip tables.
I dont 'think' its hacked!
Also, the last time I upgraded centos was from an early v4 to 4.4.2 due to major hardware failure on the server and the fact I didnt have a mirrored OS/server backup (due to cost) *but I did of course have all my sites and databases etc)
I am rather scared to upgrade Centos kernel to the latest version in part due to horror stories I have heard from others (NOT regarding Centos specifically) from kernel upgrades going wrong or compatibility issues etc that mean that I am very very reluctant to do it on our main production server..
I am imminently buying another server to act as a failover and backup for the existing one,but is keeping my current Centos install as it is and holding out to wait for a test server the best thing to do? (are there any serious security issues in 4.4.2? bugs etc?)
Or should I have confidence and get Yum to do its business!
Weird Network
Aug 9, 2007This is a very weird network issue that we are currently facing.
There are 2 servers, 1.1.1.1 and 2.2.2.2;
I can ping both IPs from my computer at the office or from anywhere else.
BUT, I cannot ping each other. For example, I log into 1.1.1.1 and cannot ping 2.2.2.2 and vice-versa.
This is very weird and I am thinking this is not OS related and something beyond that.
I was wondering if anyone of you came across this type of issue and possible direct us in the right direction.
Weird Issue
Dec 25, 2007It seems that i am facing some weird Apache issue.
I cant access my forum.domain.com but can access forum.domain.com/admin
I didnt found anything in Apache error logs,but found this in access logs
IP HERE - - [26/Dec/2007:03:13:44 +0400] "GET / HTTP/1.0" 200 22435 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727)"
Is there anything strange in that info and what does 22435 represent?
Apache :: Server Doesn't Start If Path Contains Korean Characters
Jul 10, 2014I'm testing on Windows 7 x64 SP1.
I have downloaded httpd-2.4.9-win32.zip from VC10 Win32 link which includes IPv6 Crypto apr-1.5.0 apr-util-1.5.3 apr-iconv-1.2.1 openssl-1.0.1h zlib-1.2.8 pcre-8.34 libxml2-2.9.1 lua-5.1.5 expat-2.1.0.
I unzipped and installed on my system. Configured SSL. I installed in directory C:Apache24