Ok, I've started from the beginning on this process, so I've used Opera instead of Chrome and downloaded Serendipity 1.5.1 tar.gz.
Then I've downloaded and installed FileZilla for FTP. Uploaded and overwrite serendipity.
Then, I've downloaded db_update_1.5-alpha1_1.5-alpha2_sqlite.sql.zip archive you attached before, and unzipped and overwrite the one in my server.
Then I run fixperm and modified serendipity_config_local.inc.php
Then I went to my weblog (
http://www.pajareo.com), I need to update. The next screen shows:
Code: Select all
Verify Installation Integrity
sql/db_update_1.5-alpha1_1.5-alpha2_sqlite.sql corrupt or modified: failed verification
and a little down:
Code: Select all
He encontrado los siguientes ficheros .sql que se necesitan ejecutar antes de que puedas continuar usando normalmente Serendipity:
._db_update_1.5-alpha1_1.5-alpha2_mysql.sql
that means that the script needs to use that file before continue using Serendipity...
So I click on the button "Yes, please" and...
that message appears again!
Code: Select all
-
Mac OS X 2��ATTR;
/ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
�����Y�Ycom.apple.quarantine0000;
/ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '���' at line 1
4b31e5ab;
/ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '4b31e5ab' at line 1
Google\x20Chrome.app;
/ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Google\x20Chrome.app' at line 1
The .sql file looks like this:
Code: Select all
create table {PREFIX}tempauthors (
realname varchar(255) NOT NULL default '',
username varchar(32) default null,
password varchar(64) default null,
authorid {AUTOINCREMENT} {PRIMARY},
mail_comments int(1) default '1',
mail_trackbacks int(1) default '1',
email varchar(128) not null default '',
userlevel int(4) {UNSIGNED} not null default '0',
right_publish int(1) default '1',
hashtype int(1) default '0'
) {UTF_8};
INSERT INTO {PREFIX}tempauthors
(realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish) SELECT
realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish FROM {PREFIX}authors;
DROP TABLE {PREFIX}authors;
create table {PREFIX}authors (
realname varchar(255) NOT NULL default '',
username varchar(32) default null,
password varchar(64) default null,
authorid {AUTOINCREMENT} {PRIMARY},
mail_comments int(1) default '1',
mail_trackbacks int(1) default '1',
email varchar(128) not null default '',
userlevel int(4) {UNSIGNED} not null default '0',
right_publish int(1) default '1',
hashtype int(1) default '0'
) {UTF_8};
INSERT INTO {PREFIX}authors
(realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish,hashtype) SELECT
realname,username,password,authorid,mail_comments,mail_trackbacks,email,userlevel,right_publish,hashtype FROM {PREFIX}tempauthors;
DROP TABLE {PREFIX}tempauthors;
When I try to open this file in my browser I get
Code: Select all
Forbidden
You don't have permission to access /sql/db_update_1.5-alpha1_1.5-alpha2_sqlite.sql on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.7a mod_bwlimited/1.4 PHP/5.2.11 Server at www.pajareo.com Port 80
Please, what can I do?