Processing Pixels: Warning: touch(): Utime failed: Permission denied

RyanTechnical SupportLeave a Comment

Problem When processing pixels, the following error appears along with some other errors: Warning: touch(): Utime failed: Permission denied Solution Please give chmod 666 to all files in the admin/temp/ directory. Also, please make sure that all permissions are set according to the instructions here: http://www.milliondollarscript.com/installation/tutorials/alpha-blending-tutorial

Why is ‘My link text’ limited to only 255 characters?

RyanTechnical SupportLeave a Comment

Problem When publishing pixels, a user is asked to enter a URL along with the description of the URL (My link text). You may notice that the link text is limited to 255 characters. Solution In the newer versions of the software, the link text was made unlimited. If you have an older version of the software, you will need to modify the database table 'blocks' to make the field unlimited. The best way to do this is with phpMyAdmin. Log in to phpMyAdmin and locate the blocks table. Click on the 'change' symbol for the alt_text field. Then from the 'Type' column, select 'TEXT' from the dop-down list and click save. (PhpMyAdmin is a MySQL database administration tool which is available on most services offered by various hosting companies. You can use this tool to manually manipulate the database & do database backups (export), and restore database backups.)

MySQL error: Field ‘Aboutme’ doesn’t have a default value

RyanTechnical SupportLeave a Comment

This article is outdated Symptom: When registering a new account, the following error appears: Insert Into users(IP, SignupDate, FirstName, LastName, CompName, Username, Password, Email, Newsletter, Notification1, Notification2, Validated) values('IP was Here, I removed', '2006-06-24 09:37:00', 'Jonny', 'T', '', 'Jonny', 'password', 'email@email.com', '', '', '', '1')Field 'Aboutme' doesn't have a default value Solution It looks like you are running MySQL version 5 with the default configuration. To ensure that the script will work with MySQL 5, you can try any of the following: 1. Find your my.ini file and replace the sql-mode line with: sql-mode="MYSQL40" Please remember to restart MySQL after editing the my.ini file. The my.ini file is MySQL's configuration file and should be located where MySQL was installed. 2. Or, configure your system so that MySQL start with the –sql-mode="MYSQL40" command line parameter. The script is compatible for MySQL 3, and 4, but requires the configuration change for MySQL 5.

MySQL error: The current MySQL user does not have permission to lock tables

RyanTechnical SupportLeave a Comment

Symptom: When selecting pixels, you may receive the following message from the script: Lost connection to MySQL server during query Dear Webmaster: The current MySQL user does not have permission to lock tables. Please give this user permission to lock tables, or turn off locking in the admin Solution Your hosting account does not support table locking. Please go to your admin section and turn off table locking in Main Config (see MySQL settings). Another (more advanced) option is to give locking permissions to the database user. This can be done using your web host's account management features. Some hosts do not support this option, for example a GoDaddy account will not let you do this.

MySQL error: User ‘name here’ has exceeded the ‘max_questions’ resource (current value: 18000)

RyanTechnical SupportLeave a Comment

Symptom UPDATE `users` SET `login_date`='2006-05-16 15:52:42' WHERE UNIX_TIMESTAMP(DATE_SUB('2006-05-16 15:52:42', INTERVAL 1400 SECOND)) > UNIX_TIMESTAMP(last_request_time) AND (`login_date` ='0000-00-00 00:00:00')User '1081195576' has exceeded the 'max_questions' resource (current value: 18000) User 'username' has exceeded the 'max_questions' resource (current value: 18000) Solution Your hosting service sets a limit of 18000 queries per hour. If you exceed this limit in an hour, then the above error will be shown. Upgrade your hosting to a package with more resources.