Search options (Page 303 of 307)

MySQL 4.1.2-alpha-nt, to copy from PunBB

Replace UDF with ALTER TABLE and MySQL 5 with MySQL 4.1.2-alpha-nt and you have exactly what I've got: that was the closest I could find, since the site kept crashing my browser

File: c:\apache\apache\htdocs\forum\11_to_12_update.php
Line: 117

PunBB reported: Unable to alter DB structure.

Database reported: MySQL server has gone away (Errno: 2006)

The script basically crashes my SQL server

And the query which causes it:
$db->query('ALTER TABLE '.$db->prefix.'posts DROP INDEX '.$db_prefix.'posts_posterid_idx');
But it seems the issue is with putting those 2 DROP INDEX in a row: when I run it outside of the script my SQL service dies too
Edit: I found the bug, although I use an earlier version of mySQL then what they list:
http://bugs.mysql.com/bug.php?id=3535

---

Userlist search  Notice: Undefined index: o_search_users in c:\apache\apache\htdocs\punbb\admin_options.php on line 525
/> Yes    Notice: Undefined index: o_search_users in c:\apache\apache\htdocs\punbb\admin_options.php on line 525
/> No
Allow searching in user list.

Damn it, I was positive I clicked on the link to the second page

Oh, and don't use a trailing / (ie: if the web address is http://www.test.com/punbb/index.php use http://www.test.com/punbb as your base URL

Nah, it's clear, I just have no clue how it would be done

sanjay: I suggested a similar idea to Rickard a month or so back

It looked something like yours, except it worked like this:
New table, viewed_thread. 2 columns, thread id and user id
When a user views a thread, their user id and the thread id is added
If someone makes a new post in the thread, all people who had viewed the thread there get their entry deleted from the table
When the user's last logged in time is updated, all of their entries in that table are deleted.
When viewing, PunBB checks against last_login and the user id's views as recorded by the table

Rickard said at the time he would take a look at it, dunno what he decided to do
Of course, using this table could be enabled/disabled if someone felt it was adding too much load (at least you should be able to)

3. Simply add to whereever the <img> tag for the avtar is displayed height=100 width=100

This will make bigger (or smaller) any image that isn't already 100x100.

So I think viewtopic.php and profile.php is where you need to check

Anyone have something free that would let me resize an NTFS partition? parted looks like it only detects NTFS, nothing else, and I want to try Linux as a dual boot too

It could work something like PunBB has right now with MD5 and SHA1 (or w/e it uses, don't remember if that's right)
If the password is stored as an MD5 hash but the server can use SHA1, then when you login it converts your password (based on the password you enter, as long as it matches of course)

http://www.parmaja.com/forum/viewtopic.php?pid=3#3

Something wrong with your stylesheet?

And how do we note when you've read one thread and not another?

I gave Rickard an idea I had though that might help with this...