76 Reply by pedrotuga

(17 replies, posted in PunBB 1.2 troubleshooting)

mmm... i came across another problem...
When i try to edit the forum permitions the only thing i get ( besides header and footer )
is an empty error message.

I enabled both debug mode and show queries. I don't get any error message, but this is the executed queries...

0.00086      SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=2
0.00016     UPDATE online SET logged=1194236640 WHERE user_id=2
0.00020     SELECT * FROM online WHERE logged<1194236340
0.00027     SELECT COUNT(id) FROM reports WHERE zapped IS NULL

What can this be...?

Go to forum: PunBB 1.2 troubleshooting

77 Reply by pedrotuga

(5 replies, posted in PunBB 1.2 discussion)

what does that means?
Do you have a voting system on punlancer?

Go to forum: PunBB 1.2 discussion

78 Reply by pedrotuga

(5 replies, posted in PunBB 1.2 discussion)

Please contact me to via email.
Use the email form.

Go to forum: PunBB 1.2 discussion

79 Topic by pedrotuga

(0 replies, posted in PunBB 1.2 modifications, plugins and integrations)

This plugin allows you to mantanin alphabetical clickable lists of topics of one or more forums in the content a message.
Using this plugin uncarefully may result on serious data losses. If you are performing other operations besides updating your lists, you might consider backing up your database before proceding.
The posts in which you store the lists must be created previously. Please check their ids carefully as all their content will be overwritten.
Mixing topic ids with post ids is a comon mistake, make sure you enter the post id and not the topic id.
Depending on the database engine you use it's also recomended to hack the datatype of the message body so the list can fit in it
This plugin doesn't suport list edition, if you need to modify a list you have to create a new one and delete the old one.

Ok, this needs a lot of work if you want to make this a proper plugin with proper error handling and a better interface. as it is now it just works.

Istallation:
download the file below, name it something like AP_tlg.php and place it in your plugins directory.

download:
http://pastebin.ca/raw/760988

Go to forum: PunBB 1.2 modifications, plugins and integrations

80 Reply by pedrotuga

(17 replies, posted in PunBB 1.2 troubleshooting)

By the time i wrote the last message, no. The autoincrement values were messed up as well the indexes and some column proprities in almos all the tables.

But i think i fixed it all now.
I took the create table statements from a clean install ant the inserts from a mysqldump -t ( without the create table statements )

Everything appears to be working now.

This database is the most adventured one i have, it was a phorum instalarion from the begging, then i migrated it to punbb and switched it from mysql to sqlite to give it a try. Now, i am moving server again i had to migrate it back to mysql due to lack of sqlite support. Pretty amazing how everthing always works after all.

Thanks for the help everybody, i didn't even know that there was such things as debug mode or query dumps in punbb, very handy.

Go to forum: PunBB 1.2 troubleshooting

81 Reply by pedrotuga

(17 replies, posted in PunBB 1.2 troubleshooting)

Ok... there is this error that i am not sure if is related with indexes or charsets:

INSERT INTO search_words (word) VALUES('olá'),('finalmente'),('pronto'),('novo'),('fórum'),('longo'),('periodo'),(forum),...

the words 'fórum' and 'forum' aparently violate the primary key despite being diferent.

I will try to create the database using a dump from a clean install and insert only the data . Thanks

Go to forum: PunBB 1.2 troubleshooting

82 Reply by pedrotuga

(17 replies, posted in PunBB 1.2 troubleshooting)

PunBB reported: Unable to insert search index words

Database reported: Duplicate entry '0' for key 1 (Errno: 1062)

There is some trouble with mysql index, i think i screw up my database a little bit.

My search_words table has to indexes for the id column... is it supposed to?

phpmyadmin gives this warning:

The following indexes appear to be equal and one of them should be removed: PRIMARY, search_words_id_idx

Go to forum: PunBB 1.2 troubleshooting

83 Topic by pedrotuga

(17 replies, posted in PunBB 1.2 troubleshooting)

I migrated a forum i had from sqlite to mysql because i moved to a server without sqlite support, i already managed to put the whole thing working, well.. almost.

I can't insert any data. It's not a user permition error, i checked that.

It's some trouble with th search index but i don't know how to fix it.

Here's the whole story:

I created a dump from my old sqlite database, then, when i was runing it on my mysql server it was throwing duplicate keys errors on the search words table. I though it was kind of weird, but i simply removed the INSERT statements for the three tables that hold the search index. I left only the CREATE table statements and plan to rebuild the index afterwords.

Now that i have the forums up again with mysql i can't rebuild the index nor create a post. This is the error i get:

Error: Unable to insert search index words.

Another strange thing... when i go the the 'rebuild search index' page it shows 0 instead of the id of the oldest post which is like 5989.

Any tips?

Go to forum: PunBB 1.2 troubleshooting

84 Reply by pedrotuga

(3 replies, posted in General discussion)

I am coding with codeignitor framwork now, they use their own.

Otherwise i just go for native functions.

Go to forum: General discussion

85 Reply by pedrotuga

(5 replies, posted in General discussion)

firebug extension for firefox can be very handy when debugging css.

Go to forum: General discussion

86 Reply by pedrotuga

(4 replies, posted in PunBB 1.2 modifications, plugins and integrations)

That's really cool.

But it needs some debugging. I tried it in opera and firefox but there is a problem:
It shows a huge purple square on top of the page. In opera it doesn't ever go away, so your site is unbrowsable. I am a flash illiterate, is there a way of making that background transparent or so?
I would defenately go for something like this in some sites of mine.

Here's a screenshot to ilustrate the problem
http://www.hdd.pt//images//1076135482punpeel.png

Go to forum: PunBB 1.2 modifications, plugins and integrations

87 Reply by pedrotuga

(17 replies, posted in PunBB 1.2 show off)

Punbb is no doubt a cool phenomena... like... facebook has just been featured on world-wide news, it's a huge talk about it the last days... and when it comes to set up a comunity they pick a software developed by one single person in his spare time until not so long ago.

No offense to other forum softwares out there, but just compare the amount of people and/or money involved in punbb with vbulletin or phpbb.

Punbb rocks

Go to forum: PunBB 1.2 show off

88 Reply by pedrotuga

(11 replies, posted in Feature requests)

You can alternatively cron a sql query to clean the ips from your database.
You will always have the ips since the last clean up on your database. I guess that's not as clean as you want your database to be, but it keeps your punbb instalation as it is.

Go to forum: Feature requests

89 Reply by pedrotuga

(14 replies, posted in General discussion)

How do vb modules work?
xml code overlay, hooks? manual code hacking?
do they get stored on the db, or in a text file?

Go to forum: General discussion

90 Reply by pedrotuga

(14 replies, posted in General discussion)

In one of my forums I would because i believe it comes with good anti-spam solutions out of the box.
But i would have to spend the money in higher server specs so...

It has a lot of other cool features too, some of them really practical, but i still prefer punbb. Punbb is actually more suited for handle big sites.

The problem with punbb now is that it doesn't support other plugins besides the administration ones. I blieve that, a while after 1.3 arrival, there will be many available plugins for punbb and that they will be way more popular than they are now. I strongly believe punbb can become as powerful as vb.

aahh... damit! cant wait.

Go to forum: General discussion

91 Reply by pedrotuga

(11 replies, posted in General discussion)

that depends on what you are documenting.

Go to forum: General discussion

92 Reply by pedrotuga

(9 replies, posted in PunBB 1.2 troubleshooting)

mmm... cool.
I think i will replace the akismet module by this.

I went on spamhaus and gave quick look at the documentation but still don't understand how it works.
How is the lookup made?... like... in the code you posted above... where is the actual lookup?
I don't see any remote data retrieval.. quaker, can you explan in more detail?

Go to forum: PunBB 1.2 troubleshooting

93 Reply by pedrotuga

(11 replies, posted in General discussion)

Unfortunately a forum is not the answer.

I would recomend something like a threaded discussion per item.

A bit like the forum portal systems.

Go to forum: General discussion

94 Reply by pedrotuga

(124 replies, posted in News)

I think the only possible concern, not likely to happen at all IMO though,  is the consequences to comunity support, which is basically THE support punbb has.
All other concerns don't appear valid to me. Dunno, just my 2 cents.

YAY! a gossip thread! bah...

Go to forum: News

95 Reply by pedrotuga

(14 replies, posted in General discussion)

Sage is my absolute favorite!
It displays a page with all the entries and their content. Like.... you dont need to click each item one by one.
I doesnt have a pop up feature though.

I've tried some other stuff but nothing ended up being as close to sage when it comes to be practical.

Go to forum: General discussion

96 Reply by pedrotuga

(43 replies, posted in PunBB 1.2 modifications, plugins and integrations)

ahhh... i am not picturing the viewtopic.php very clearly now. But are you sure you can move the template catch code to the end of the script?

Fantasma: Sorry i took so long to repply, i forgot about this thread.
I would do this some other time, but at this time i cant afford to put time on small code project. I would do it for a some money, but to be honest i feel kind of heavy conscience charging for a plugin to something that is kindly available for free.
But, more important than that there is another problem.
This module would require code hacking and database hacking, which basically means that you would have to manually make all the painfull changes when you update your forum. And it would all probably be useless when punbb 1.3 comes.

version 1.3 will have hooks and the plugins will be stored in the database. That will be the perfect conditions for the development of a mod like this.

If you can wait until 1.3 I think this mod should not take so long to pop up. Probably coded by me... i dunno.

Go to forum: PunBB 1.2 modifications, plugins and integrations

97 Reply by pedrotuga

(2 replies, posted in PunBB 1.2 discussion)

Yeah... that's the way to go.
I just dropped the idea in here as quick as it popped in my head. It was way too undercook, it was raw actually.
In my raw idia the placeholders would only be used if the number of topics would 'reach' it. But, i agree, that was acompletely dumass way of implementing this.

Now that i think about it there's absolutely no need for a template, a hook on the top of the post loop would be enough indeed. Another one on the bottom might be handy to.

Damn... cant wait for 1.3... the new plugin system will rock, i will finally hack my forums like hell without worring about updates.


EDIT: as i checked a topic about a keyword insertion i thought about some spots to place hooks.
In between the post form fields. In case sombody wants to ad extra fields. Ok, that's probably thought trhough already.

Go to forum: PunBB 1.2 discussion

98 Topic by pedrotuga

(2 replies, posted in PunBB 1.2 discussion)

Hope this is still on time.

I have no idea how the hook system will work nor if the template engine is going to change radically.

A feature that is widely used in vbulletin is ads after the first post of a topic view.

I think this is cool mod and extremely useful these days when advertise is the only income of millions of sites.

this is just an idea, but i think it could bring a lot of flexibility to punbb and make a lot of things doable just by using a plugin rather than going and hack the code.

There could be a topicview.tpl with placeholders for each message #...

like

<topicmessage1>
<between1-2>
<topicmessage2>
<between2-3>
<topicmessage3>
...

something like that.
Then, if each of them would call a hook it would be possible to put php code in pretty much every spot of the script.

This would be very handy because it would possible to do a lot of stuff without hacking the code, and since punbb1.3 pluggins will store actual php code on the database, then one could play around with a specific message # and keep those changes through an update.

I am not sure i made this very clear... anyway, it's just an ideia. There is many ways to achieve this freedom

Go to forum: PunBB 1.2 discussion

99 Reply by pedrotuga

(20 replies, posted in PunBB 1.2 discussion)

couls somebody put up a demo instalation?

Go to forum: PunBB 1.2 discussion

100 Reply by pedrotuga

(124 replies, posted in News)

At first i got worried and betrayed in some way. Like, it might be within the 20% of the code developed by the 80% of the ppl involved, but i proudly contributed with some small mods/plugins and i actually have some more on it's way. It felt like there was money involved in something i participated actively because i believed it was a free open source project in all its sense.
I felt like this this was going the same way mambo did.
Don't nail me for having this reaction, i wouldn't be honest if i wouldn't mention it when i say my opinion about this.

Now as i red the thread though i changed my opinion.
Punbb has been build up for free, the code is there, available for everybody at cost zero. Rickard, the dev team and all other code contributers have put their time/work without asking anything in return. I don't think anybody has the right to complain. OK, one has the right to feel sad or disappointed about this. But hey, Rickard even said himself that he would fork punbb if necessary.

This might be a good opportunity for everybody to think about how valuable this software is and how cool is to have it for free.

If the dev team would give up of this project today we would have to accept, there's no responsibility by anybody twards nobody.
Besides that, the code would still be as free as it is today, and somebody else could assume the development, that's what open source is... i guess.

On the other hand, i haven't really understood why did the company needed to buy the copyright in order to do whatever they want to do.
I think the worst scenario would be a fork, but punbb has it's license precisely to protect itself whenever necessary.

Keep up

Go to forum: News