Go through below code and rub sql queries that need to get executed.
INSERT INTO `eav_attribute` (
`attribute_id` ,
`entity_type_id` ,
`attribute_code` ,
`attribute_model` ,
`backend_model` ,
`backend_type` ,
`backend_table` ,
`frontend_model` ,
`frontend_input` ,
`frontend_label` ,
`frontend_class` ,
`source_model` ,
`is_required` ,
`is_user_defined` ,
`default_value` ,
`is_unique` ,
`note`
)
VALUES (
NULL , ‘1′, ‘karat10′, NULL , NULL , ‘varchar’, NULL , NULL , ‘text’, ‘Karat 10 ‘, NULL , ”, ‘1′, ‘0′, ‘0′, ‘0′, ”
);
After insert query, the attribute generated is my case is 154. Next this attribute needs to be associated to an attribute set, …

just add below code in your .htaccess and save your hrs…
AuthName “Restricted Area”
AuthType Basic
AuthUserFile “your htpasswd file path”
AuthGroupFile /dev/null
require valid-user
SetEnvIf Request_URI “\/$” allow
SetEnvIf Request_URI “\/css/(.*)$” allow
SetEnvIf Request_URI “\/js/(.*)$” allow
SetEnvIf Request_URI “\/images/(.*)$” allow
# write above line for all folder those need public access
Order allow,deny
Allow from env=allow
Satisfy any

allow from all
Satisfy any

here is simple script to remove extra white spaces from each field of database table and get log record of how many fields age getting affected ! !

Often when one installs the CMS Made Simple on an active server online; they face a problem with the Tiny MCE editor in the pages section and hence the content cannot be modified via the editor.
I have provided three known solutions to this problem:
1) Change the permission on the modules directory to 755 if it already isn’t.
2) Try uninstalling the Tiny MCE and reinstalling it.
3) Try uninstalling the Tiny MCE and replacing it with an older version.

Recently I have face strange issue on wordpress which is “public_html/wp-includes/pluggable.php on line 868 wordpress issue” error at the time of login on wordpress website.
Issue: public_html/wp-includes/pluggable.php on line 868
Solution: This kind of error is normal for wordpress. This can occur due to some spaces after ?> ( end of php code ) in your php code files. So, you need to check your last accessed files and removed spaces if there and try again accessing that page. Hope it helps for wordpress developers.
- Tejas

Follow the below code to import mysql database using command line.

mysql -uUSERNAME -pDATABASE < DATABASE_FILE.SQL

Format: mysql -uroot -ppasword -hlocalhost database-name < sql_dump_file_name.sql

Correct Example: mysql -uroot -palakmalak -hlocalhost oca < cerb4oca.sql
Note: Do not go to mysql console. Just go to the directory where your backup file resides.
Note: Do not use -u space username like -u root ( this will not work ) use -uroot -ppassword -hlocalhost

Wrong Example: mysql -u root -p abc123 localhost < mytest.sql

where root is USERNAME of MySQL, abc123 is DATABASE of MyQL and mytest.sql is …

some has experienced that when clicked on some link blank page is displayed
that problem is there because of add page process of zencart
to add page in zencart we have to create four pages
* A new directory, includes/modules/pages/myNewPage/, containing a file called header_php.php
* A new file in the directory includes/templates/template_default/templates called tpl_myNewPage_default.php
* A new file, includes/extra_datafiles/myNewPage.php, defining your new page’s filename for the Zen Cart™ system
* A new language file, …

There may be certain servers which do not allow curl options so there is a alternate option for it. We can use commands such as file open, fgets and perform the same functionality as curl. Read the whole post for the solution

Open a terminal window and run the following commands:
sudo apt-get install apache2 mysql-server php5 libapache2-mod-php5 php5-xsl php5-gd php-pear libapache2-mod-auth-mysql php5-mysql
sudo sed -i ’s/; extension=mysql.so/extension=mysql\.so/g’ /etc/php5/apache2/php.ini
That’s a series of 3 spaces after ’s/;
sudo /etc/init.d/apache2 restart
Reboot and you’re done!

Click Start
Then – RUN
Type CMD press OK
Type this command in command prompt
mstsc /v:00.00.00.00 /f /admin
Replace 00.00.00.00 with your server’s IP Address or server name. e.g.SERVER