phpMyFAQ

Unfortunately this is a heavily customized PMF and we haven't been able to upgrade. we are still on 1.5.4. The PMF has been working great but suddenly the pdf feature stopped working and we can not generate any pdf files. I just get a blank page, no errors.
I looked inside the PDF folder and it had ...

The dump is about 1.2 megs.
Should I send it to your email?

Our PMF is running slow. We tried different servers with about the same results. We have hardcoded links on the frontpage but we have noticed the same speed issues with the default menus. There are 424 articles distributed in about 80 categories. This PMF is not live yet and it has lot of small ...

In our case is useful because the support representative can give a customer the ID number for the specific article hence speeding the support call. Also if there is an error or needs to update an specific article the customer can find the record quickly to advise the support center so it works both ...

In order to fix this issue, the following line of code (in red) was added to the inc/functions.php:

/**
* build_insert()

* This function builds the the queries for the backup
*
* @param string query
* @param string table name
* @return array
* @access public
* @author Meikel Katzengreis <meikel ...

Now that you have implemented the hack "search for article id" for users, add this code to be able to find articles ID in the admin area:

Find the file admin/record.show.php and add the code in red . (line 50)

} else if (isset($_REQUEST["aktion"]) && $_REQUEST["aktion"] == "view" && isset ...

Here is the ID search hack we implemented in our PMF:

In the functions.php find: (line 1261 to 1320)

if (0 == $num) {

$keys = preg_split("/\s+/", $begriff);
$numKeys = count($keys);
$where = '';
for ($i = 0; $i < $numKeys; $i++) {

if (strlen($where) != 0 ) {
$where = $where." OR ...

Thorsten:

You mention you had a hack to search by ID # or said it was easy. Can you share it with us? (admin and public)

Thanks.

Our PMF Board is close to be public!

Thanks for the script! I fixed the DB manually last night.
I also found that there were some tab characters I had to delete to make the articles valid again.

Great program though.

You exactly right. The single quote was not coded correctly. So any article that has a single quote generated an error.
The only backups that I did were with 1.5.2 and 1.5.4 being the last one the most current with heavy editing so I can't go back to the 1.5.2 one.
I better start fixing 1 meg ...

That's what I did, before I updated the DB I made a fresh backup.
. But I didn't get the error that you mention.


Most of the unloaded records show you "You have an error in your SQL syntax near" embeded near the end of the entry

http://www.traxxas.com/KnBs/snap02.jpg

http://www.traxxas.com ...

Updated from 1.5.2 to 1.5.4,
backed up the database .sql
Made some changes on the DB document
Uplodaded DB
Now from 340+ entries, it only shows 190
Tried to upload unchanged DB with same results.
I can see the entries on the backup .sql document but they are not showing up on the faq.

On the admin ...

We are just waiting for Thorsten 1.5.4. and 1.6

Go Thorsten!

Thorsten:

Can you show us how to add this ID search to the admin area as well as the public? This will make finding articles for editing a lot easier.

Thanks.

if you add a slash between words after another word the search will show nothing or errors:

My example was shifting forward/reverse but you can get equal results with s f/r or something similar.