2.5 RC2 (15/06/09 build) - multiple issues

[sallokatallo]

Hello everyone,

I am experiencing the following problems:

1. The + button for adding users to a group doesn't work
2. The 'Sticky' articles functionality doesn't seem to work - when changed manually through the DB, it works.
3. When entering the article ID in the search box, the article is retreived successfully, however, it says "No categories found" and the Question/Title of the article is missing.
4. Deleting an attachment in an FAQ gives an error. "An error occurred while deleting the attachment."
5. Export to PDF issues - getting the following error - exactly as it appears below - there seems be a "/" missing:


phpMyFAQ warning [2]: getimagesize() [function.getimagesize]: php_network_getaddresses: getaddrinfo failed: Name or service not known in Pdf.php on line 545

phpMyFAQ warning [2]: getimagesize(http://faq.epikip.netattachments/2/Voicemail.JPG) [function.getimagesize]: failed to open stream: Success in Pdf.php on line 545
PMF_HttpStreamer Class error: unable to send my headers: someone already sent other headers!

That's it for now

[kjusupov]

Hi all,

I've below errors when I search something:

Code: Select all

phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: relation "xaxfaqsearches_id_seq" does not exist in Pgsql.php on line 91
phpMyFAQ warning [2]: pg_result(): supplied argument is not a valid PostgreSQL result resource in Pgsql.php on line 327
phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "xaxfaqsearches_pkey" in Pgsql.php on line 91

Check from DB:

Code: Select all

dev_phpmyfaq=# \ds
                     List of relations
 Schema |             Name              |   Type   | Owner  
--------+-------------------------------+----------+--------
 public | xaxfaqadminlog_id_seq         | sequence | synack
 public | xaxfaqcategories_id_seq       | sequence | synack
 public | xaxfaqchanges_id_seq          | sequence | synack
 public | xaxfaqcomments_id_comment_seq | sequence | synack
 public | xaxfaqdata_id_seq             | sequence | synack
 public | xaxfaqdata_revisions_id_seq   | sequence | synack
 public | xaxfaqglossary_id_seq         | sequence | synack
 public | xaxfaqgroup_group_id_seq      | sequence | synack
 public | xaxfaqlinkverifyrules_id_seq  | sequence | synack
 public | xaxfaqnews_id_seq             | sequence | synack
 public | xaxfaqquestions_id_seq        | sequence | synack
 public | xaxfaqright_right_id_seq      | sequence | synack
 public | xaxfaqsessions_sid_seq        | sequence | synack
 public | xaxfaqtags_tagging_id_seq     | sequence | synack
 public | xaxfaquser_user_id_seq        | sequence | synack
 public | xaxfaquserdata_user_id_seq    | sequence | synack
 public | xaxfaqvisits_id_seq           | sequence | synack
 public | xaxfaqvoting_id_seq           | sequence | synack
(18 rows)

as well as these when I add new FAQs:

Code: Select all

phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "xaxfaqcategory_user_pkey" in Pgsql.php on line 91
phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key value violates unique constraint "xaxfaqcategory_group_pkey" in Pgsql.php on line 91
The changes were saved successfully.

Check from DB:

Code: Select all

dev_phpmyfaq=# SELECT * from xaxfaqdata_user;
 record_id | user_id 
-----------+---------
         2 |      -1
         3 |      -1
         1 |      -1
         4 |      -1
(4 rows)

My System Information:

Code: Select all

phpMyFAQ Version: phpMyFAQ 2.5.0-RC2
Server Software: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8k DAV/2 PHP/5.2.10
PHP Version: PHP 5.2.10
Register Globals: off
Safe Mode: off
Open Basedir: off
Database Server: Pgsql
Database Client Version: 8.3.7
Database Server Version: 8.3
Webserver Interface: APACHE2HANDLER
PHP Extensions: date, libxml, openssl, pcre, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, session, filter, ftp, gd, gettext, hash, iconv, json, ldap, mbstring, mcrypt, mhash, mime_magic, mysql, SimpleXML, odbc, SPL, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, Reflection, standard, mysqli, soap, SQLite, exif, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, apache2handler 

[kjusupov]

Hi guys,

Some more, when I go as "admin" --> Configuration --> URL Verifier:

Code: Select all

URLs prefixed with items below will be issued warning regardless of whether it is valid.
Use this feature to detect soon-to-be defunct URLs
phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: LIMIT #,# syntax is not supported HINT: Use separate LIMIT and OFFSET clauses. in Pgsql.php on line 91

[Thorsten]

Hi,

ah, seems to be Postgre-related bugs. We'll fix this.

bye
Thorsten

[kjusupov]

Hi,

The bug with search functionality (default search) is fixed with below:

Code: Select all

CREATE SEQUENCE xaxfaqsearches_id_seq start 2;

there is still problem when you do "advanced search" (default advanced search) without selecting a category

Code: Select all

phpMyFAQ warning [2]: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "AND" LINE 1: ...= 'en' AND xaxfaqcategoryrelations.category_id = AND xaxfaq... ^ in Pgsql.php on line 91

but the same search works fine if you select a category and search...

[Thorsten]

Hi,

please try the next SVN build tomorrow (2009-07-07) and run the update script. I hope we fixed all reported issues.

Thanks for testing!

bye
Thorsten

[sallokatallo]

Hey Thorsten,
I hope you had fun in Vancouver and Seattle...

Does tomorrow's SVN include the issues listed in the first portion of the post?

1. The + button for adding users to a group doesn't work
2. The 'Sticky' articles functionality doesn't seem to work - when changed manually through the DB, it works.
3. When entering the article ID in the search box, the article is retreived successfully, however, it says "No categories found" and the Question/Title of the article is missing.
4. Deleting an attachment in an FAQ gives an error. "An error occurred while deleting the attachment."
5. Export to PDF issues - getting the following error - exactly as it appears below - there seems be a "/" missing:

Thanks

[Thorsten]

Hi,

I hope you had fun in Vancouver and Seattle...

yes, should be all fixed.

Does tomorrow's SVN include the issues listed in the first portion of the post?

1. The + button for adding users to a group doesn't work
2. The 'Sticky' articles functionality doesn't seem to work - when changed manually through the DB, it works.
3. When entering the article ID in the search box, the article is retreived successfully, however, it says "No categories found" and the Question/Title of the article is missing.
4. Deleting an attachment in an FAQ gives an error. "An error occurred while deleting the attachment."
5. Export to PDF issues - getting the following error - exactly as it appears below - there seems be a "/" missing:

bye
Thorsten

[cozbaldwin]

HI - Just upgraded from 2.0.16 to 2.5 RC3. (no thread for RC3 yet so Im asking it here)
At first glance, everything appears good - but the top10, latest5 aren't showing up. They were showing up before.
It could have been something I did before, poking around in the code, but I'm not exactly sure. Ill keep poking around, but im just reporting this now in case Im not the only one.

By the way - the documentation for upgrading is a bit misleading. It says to delete everything except the data file and the template directory. Then run the install script. But It skips the part that tells the user to upload/overwrite everything from the new package except those files previously mentioned.

[Thorsten]

Hi Coz,

some parts of the template system changed. Please use the startpage.tpl from the folder template/ from the phpMyFAQ 2.5 package and evyerthing will be okay.

bye
Thorsten