Search options (Page 4 of 6)

Hi.

I'm (admin) trying to edit a users profile by just clicking save.

When locating the user with the search engine and browsing to the users profile from a link from within "http://domain.com/forums/" it works fine since the base url option is set to "http://domain.com/forums".

But if I have a link to the users profile from another url like http://domain.com/ -> http://domain.com/forums/profile.php?id=1234 and then hit save, I get HTTP_REFERER error.

Should this really happen since im in the correct path when pressing the save button?

like this: 1:or, 2:or

The text above is:
1 : or, 2 : or (no spaces)

I did not have the "yikes.png" and got only a box instead of image.

I actually dont know if this truly could be named as a bug though..

This is how it looks like sometimes in FF only. I have the punbb css, AND an own one, but I dont know where to look for the problem? What could cause this?

Btw, the example is from PM-mod, but the problem is in the forum index also.

If i hit the reload button after it looks like this it's showed correctly, this happens only sometimes when i enter the page through a link.

Im using this on all my pages outside of site.com/forum/

define('PUN_ROOT', './forum/');
require PUN_ROOT.'include/common.php';

This gives me $pun_user to use on my pages.

Anyway, when setting a ban, the user is rejected even if site.com/ is visited (not only site.com/forum/). This is how it should be i guess....

But the problem is that when banned users visit site.com/ all the links and stylesheets are wrong. Links refer to site.com/login.php, site.com/profile.php and so on instead of site.com/forum/login.php and site.com/forum/profile.php ...

well, it's actually no big problem. Banned users are banned, and no harm if what they see is not perfect, but anyway, I thougt I should bring this up. Am I doing something wrong maybe?

Hey, maybe someone have a clue about this:

I have performance issues with fulltext search in mysql.
If I use FORCE INDEX (the_fulltext_index) a specific query takes 0.7s to execute (only 6000 rows and no large columns), If I instead use IGNORE INDEX (the_fulltext_index) the query takes still 0.7s to execute. That probably means something is not right? Explain for the query says the fulltext index is used on the first query (force) but not on the other (ignore) ... but the results are the same. I have NO clue of what to do now...

This is the explain WITH force index on the query:

mysql> explain SELECT a.adid, a.catid, a.areaid, a.subject, a.price, a.mileage, a.year, a.timestamp, a.type, a.images, i.filename AS first_image, i.folder FROM ads AS a FORCE INDEX (cs_idx) LEFT JOIN ads_images AS i ON i.adid = a.adid WHERE MATCH (subject, content) AGAINST ('+helt +ny +ouppackat +kamera +med +garanti' IN BOOLEAN MODE) AND a.visible = '1' AND type = 's' GROUP BY a.adid ORDER BY a.adid DESC LIMIT 0, 50;
+-------+----------+---------------+--------+---------+------+------+----------------------------------------------+
| table | type     | possible_keys | key    | key_len | ref  | rows | Extra                                        |
+-------+----------+---------------+--------+---------+------+------+----------------------------------------------+
| a     | fulltext | cs_idx        | cs_idx |       0 |      |    1 | Using where; Using temporary; Using filesort |
| i     | ALL      | adid_idx      | NULL   |    NULL | NULL |    1 |                                              |
+-------+----------+---------------+--------+---------+------+------+----------------------------------------------+
2 rows in set (0.00 sec)

And this is how the index looks on the table:

mysql> show index from ads;
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| ads   |          0 | PRIMARY    |            1 | adid        | A         |        6000 |     NULL | NULL   |      | BTREE      |         |
| ads   |          1 | areaid_idx |            1 | areaid      | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |
| ads   |          1 | catid_idx  |            1 | catid       | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |
| ads   |          1 | type_idx   |            1 | type        | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |
| ads   |          1 | cs_idx     |            1 | content     | A         |        6000 |     NULL | NULL   | YES  | FULLTEXT   |         |
| ads   |          1 | cs_idx     |            2 | subject     | A         |        6000 |     NULL | NULL   | YES  | FULLTEXT   |         |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
6 rows in set (0.00 sec)

if I dont use "+" in the boolean search and search for only "helt ny ouppackat kamera med garanti" (the table have this frase in every row of the 6000 btw) the query takes about 4 seconds.

Could anyone please suggest anything to do? Im happy if I could even recieve only clues, then I could search further for a solution. Thanks...

/C

Hi!

I want to search in boolean mode in mysql and need to make it user friendly.

Examples of search phrases I want to make:

"apple AND pear NO orange" should give "+apple +pear -orange"
"apple pear NO orange" -> "+apple +pear -orange"
"apple OR pear NO orange" -> "apple pear -orange"
"apple NO pear AND orange" -> "+apple -pear +orange"

and so on....

Any script suggestions?

edit: i dont want the user to be able to write "apple pear orange" and then the search returns everything containing apple pear or orange, a search only for "apple pear orange" should result in a search after "+apple +pear +orange".