Duyệt theo tháng January, 2010

Limit on Number of Indexes on MySQL Table

Question: I use MySQL 5.0.13RC under Linux I’m trying to create a table with 70 foreign keys and the next message appear : ERROR 1069: Too many keys specified. Max 64 keys allowed Can I avoid/modify this restriction easily? Thank you all.

MySQL Error : Duplicate entry ‘XXX’ for key 1

Question: When i register then get erro Database error in vBulletin 3.8.4: Invalid SQL: INSERT INTO user (options, parentemail, email, username, salt, passworddate, password, usergroupid, languageid, usertitle, customtitle, showbirthday, birthday_search, birthday, timezoneoffset, ipaddress, displaygroupid, joindate, lastvisit, lastactivity, autosubscribe, showvbcode, threadedmode, reputationlevelid, reputation, pmpopup, maxposts, daysprune, startofweek) VALUES (45096311, ”, ‘minhtan@yaoo.com‘, ‘ngominhtan’, ‘=M{‘, FROM_UNIXTIME(1263954171), ‘d5b85766342f5515dc90e10a9393da52′, 2, [...]

Content Encoding Error vbullletin

Question: Hello If I try and load a page from the my main vbullletin for example: http://community.basenotes.net/showt…32#post1251532 I am faced with an error in firefox like this Content Encoding Error The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression. I’ve not changed any settings [...]

How To Install And Configure Advanced Policy Firewall (APF) On CentOS 5.3

This tutorial explains how you can install and configure APF – an interface to IPTables which lets you easily configure a full featured firewall to secure servers and workstations connected to a network. This guide describes an example installation on a server with cPanel but it’s only a matter of port numbers which must be [...]

OpenVPN Server On CentOS 5.2

So your users need access to Exchange and data from outside your organisation. Sure you can set up RPC over HTTPS and various other tools to access the data. I just find OpenVPN very good, convenient and reliable. And after battling to find a good simple HOWTO, I put this together. It’s a quick and [...]

Multiple mySQL insert using textarea

Question: I am trying to create a form where I can cut an paste records in a textarea and submits each record as new row in mysql. Example: I have records such like this. —- Toyota Honda BMW —- I would like to copy the text and paste it in a textarea then hit submit.  [...]

Linux Security Notes – AIDE File Integrity

AIDE (Advanced Intrusion Detection Enviornment) is a tool to check the file integrity. It is an opensource substitute for TRIPWIRE. It allows to take snapshots of all the major configuration files, binaries as well as libraries stats. And helps to find which binaries have been changed in case of compromisation of the system. This can [...]

Copy one file to multiple directories

Question: I need to be able to copy one file to multiple directories, the only problem is the multiple directories have item that is unknown. So I have a file that is located in c:\folder1\somefile.txt I want to copy this file to the users home directories: \\server\homes\user1\folder1\ \\server\homes\user2\folder1\ \\server\homes\userA\folder1\ \\server\homes\userX\folder1\ \\server\homes\user5\folder1\ ….. Everything is the [...]

Issue with ASP.NET not calling Page_Load

Question: Hi, I have an issue with an ASP.NET web page that has been developed to log people into an external application. Assuming we open IE and have all cookies, internet files and cache cleared, and enter the address of the website it works correctly and performs its function. If I close IE and reopen [...]

Mysql Select statement using may or

Question: I have to update my mysql db. I have to update a  field if it matches 1 of 184 zipcodes. I have a list of zipcodes but dont have any idea of how to created the statment. UPDATE `cart`.`cart_cust` SET `s_county` = ‘2′ WHERE  (zipcode could be one of 184) Solution: UPDATE `cart`.`cart_cust` SET [...]

Nhập địa chỉ email của bạn: