upgrade to ver. 2.6.5

[nobby]

Hi,

I checked the table faqdata as follows:

mysql> describe faqdata;
+------------------+---------------+------+-----+----------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------+------+-----+----------------+-------+
| id | int(11) | NO | PRI | NULL | |
| lang | varchar(5) | NO | PRI | NULL | |
| solution_id | int(11) | NO | | NULL | |
| revision_id | int(11) | NO | | 0 | |
| active | char(3) | NO | | NULL | |
| sticky | int(11) | NO | | NULL | |
| keywords | text | YES | MUL | NULL | |
| thema | text | NO | | NULL | |
| content | longtext | YES | | NULL | |
| author | varchar(255) | NO | | NULL | |
| email | varchar(255) | NO | | NULL | |
| comment | enum('y','n') | NO | | y | |
| datum | varchar(15) | NO | | NULL | |
| links_state | varchar(7) | YES | | NULL | |
| links_check_date | int(11) | NO | | 0 | |
| date_start | varchar(14) | NO | | 00000000000000 | |
| date_end | varchar(14) | NO | | 99991231235959 | |
+------------------+---------------+------+-----+----------------+-------+
17 rows in set (0.00 sec)

nobby

[nobby]

Hi,

I have check faqdata as follows:

Code: Select all

mysql> describe faqdata;
+------------------+---------------+------+-----+----------------+-------+
| Field            | Type          | Null | Key | Default        | Extra |
+------------------+---------------+------+-----+----------------+-------+
| id               | int(11)       | NO   | PRI | NULL           |       |
| lang             | varchar(5)    | NO   | PRI | NULL           |       |
| solution_id      | int(11)       | NO   |     | NULL           |       |
| revision_id      | int(11)       | NO   |     | 0              |       |
| active           | char(3)       | NO   |     | NULL           |       |
| sticky           | int(11)       | NO   |     | NULL           |       |
| keywords         | text          | YES  | MUL | NULL           |       |
| thema            | text          | NO   |     | NULL           |       |
| content          | longtext      | YES  |     | NULL           |       |
| author           | varchar(255)  | NO   |     | NULL           |       |
| email            | varchar(255)  | NO   |     | NULL           |       |
| comment          | enum('y','n') | NO   |     | y              |       |
| datum            | varchar(15)   | NO   |     | NULL           |       |
| links_state      | varchar(7)    | YES  |     | NULL           |       |
| links_check_date | int(11)       | NO   |     | 0              |       |
| date_start       | varchar(14)   | NO   |     | 00000000000000 |       |
| date_end         | varchar(14)   | NO   |     | 99991231235959 |       |
+------------------+---------------+------+-----+----------------+-------+
17 rows in set (0.00 sec)

nobby

[Thorsten]

Hi,

yes... I need the informaton, if there's any content in it... which result do you get by executing

Code: Select all

SELECT * FROM faqdata

?

bye
Thorsten

[nobby]

Hi,

Unfortunately the faqdata is empty.

mysql> select * from faqdata;
Empty set (0.00 sec)

Is there any of retrieving old faq data ?

nobby

[Thorsten]

Hi,

do you have a backup? What did you do exactly to delete all of your data?

bye
Thorsten

[nobby]

Hi,

No, I have no backup data except data in data folder.
All other data and files were replaced with new ones.

nobby

[Thorsten]

Hi,

but why did you removed all your database content?

bye
Thorsten

[nobby]

Hi,
I found I explained the situation wrongly.
The database shown before is the new data base of phpmyfaq ver 2.6.5 and I still have old database
in the other domain. I checked the faqdata in the old database and it looks there are some
data in faqdata table. I can not explain the data content as almost all output is garbled.

So I am finding the way of recovering the data. What I have to do shall be copying (export) old faqdata
and others from old database and position then in the new database. Is this correct ?

nobby

[nobby]

Hi,

I succeeded restoring database into version 2.6.5. However most of the data have been
garbled as per attached screenshot. Must I import the sql data with some language option ?

http://bit.ly/9Who3d

nobby

[Thorsten]

Hi,

you have to run the installer to convert your database data to UTF-8.

bye
Thorsten

[nobby]

Hi,

Upon running installer (~/intall/setup.php), it prompted me as
"It seems you're already running a version of phpMyFAQ.
Please use the update script."

Then I ran ~/install/update.php and still faq data in Japanese remains garbled.

nobby

[Thorsten]

Hi,

which character set are you using in your database?

bye
Thorsten