MYSQL :: Duplicate Forum Messages

Error Messages
am very new to mysql and would appreciate some advice. Where may I obtain a list of the error codes and their meanings. I have seen a list on this web site but the meaning are unclear, I need to understnd what my mistake is and how to rectify it.eg error 1058 Message: Column count doesn't match value count?What does this mean exactly?

Mysql Error Messages
Is there a way to change the way a mysql error message is displayed?
Example:
A current mysql error msg:
Warning: mysql_connect(): Can't create a new thread (errno 11).
If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in
hsphere/local/home/ACCOUNT_NAME/MYRANDOMSITE.com/path/to/file.php on line 4

Is there a way to hide the section that displays my account name?

How To Turn On Error Messages
I was wondering if some kind soul could enlighten me as to how I ::

1. turn on error message logging;
2. change the level of error message logging, and finally;
3. what is the highest level of error logging?

MySQL4 Error Messages
the meaning of SLQ error 14252 or, better still, tell me where there is a list of these numbers and theior meanings?

Error Messages In Function
First, I cannot use PHP or C. My requirements are for a pure MySQL interface.
I am using MySQL v5.0.Is there any way to output a message to the console from a FUNCTION?This is needed mostly for error handling, but all error handling functionality
seems to only point to PHP or C, which I cannot use.

In postgresql this is easily done with RAISE NOTICE 'msg';
Like in Ingres it can be done with WRITE 'msg';

But I am baffled that MySQL does not have any equivalent functionality.

How To Get MY SQL Query Messages Into A Single Outfile
I want to run set of queries and want to get the messages after executing them into one outfile.

e.g when I run query "Select * from accounts", when the query is successfully executed, it gives message "1000 rows in set (0.01) sec".

I want to get all such messages from different query sets into one outfile.

Can anybody guide me on how to get the same?

Receiving Sms Messages By HTTP Push
I need to receive sms messages from my isp into a php database & am a real php newby, so apologies in advance if this has been covered. I did look through the forum!

According to the docs, "The HTTP push API allows incoming SMSs, including replies to outgoing SMSs, to be routed back to you via HTTP. HTTP GET is used, and all data are sent as simple query parameters."

Is it as simple as writing a get statement, in say, "http://www.mydomain.dom/incoming/deliver.php?pass=blahblah" and having that insert the parameters sent into the database? Then upload the deliver.php file to my server and leave that to be called by the isp when sms messages arrive?

Symbols On Constraints And Error Messages
However, in my application, I want the user to be alerted if their membername OR email is already taken, by showing an error message alerting them of the problem field. What I want to be able to do is parse the MySQL error message in my application and determine which field is causing the problem. The thing is though, the error message I get from MySQL is something like this -

"Duplicate entry 'bpapa' for key 2"

OK, great... but what the heck is 2? Well I know it's "membername" and not email, but I want to establish a more meaningful name. So, I thought the symbol option would help me here... the CREATE TABLE statement now looks like this -

"UNIQUE KEY `member_unique_membername` (`membername`)"

And the problem is, I still get the error message telling me that there is a problem with "key 2", instead of "member_unique_membername" Is there anyway to get the symbol name to show up in the error message, or is there some similar configuration I can do to get a nice, meaningful key name in the error message?

Show Extended Error Messages
how I can make MySQL show detailed error information when an error occurs.

Error Messages That Contain Table Constraint Symbols In Mysql
I'm currently porting an application using some other DB to MySQL.
The database in question has several tables with foreign key
relations. The application is written such that, on table INSERTs, if
a foreign key relation is violated, the error message is parsed for
the particular relation that is violated. As a simple example, say we
have the tables: Code:

Set Up New Forum
I would like to set up a forum on an FTP server. I have downloaded a Forum template but I do not know how to use MySQL with it. How should I upload it and make it useable for people?

I do not have the luxury of spending very much money, this would be a Guild Thread for people that play an mmorpg with me.

Wp-Forum DB
I get this problem whenever I go to my forums page.
PHP Code:

WordPress database error: [Unknown column 'sort' in 'order clause']

Forum
I am thinking of making a forum from scratch using PHP and MySQL, what would be thwe best way of doing this?

DB For A Forum.
i have worked with DB before but not with mysql and not on this level.i need to create a DB for a forum i have downloaded, but where to start?
i am using apache2triad.
i am aware i have to create a DB for the forum but i have no info on how. i create a DB and it wants to know about tables and so-on.
now what do? how many tables do i need and where will i get this info.

Forum Tree
I am trying to find an elegant solution for a forum tree, but I don't know enough about MySql.

Let me try and explain what I try:

1. Someone writes a story (A)

2. Someone gives a reaction (A1)

3. Someone else gives a reaction (A2)

4. Someone reacts to A1 (A1a)

5. Someone reacts to A1a (A1aI)

etc. etc.

I would like the order on the page to be the logical one, ie:
A
  A1
     A1a
          A1aI
  A2
  A3
     A3a
  A4
etc. etc.

What fields would I have to add to be able to fetch the entire forum in the logical order with only one query? Do I add a 'Parent' field plus an index? Or other fields? What would the query look like?

Maybe you think I should work it out by myself, and you would be right there, but I have been breaking my head over this for quite some time already.

Installing A Forum
Well im talking with my friend who is hosing my webserver.

Now when I try to install vbulletin and go and edit the config, the port is wrong. My friend says he dose not know how to figure out with port im on. So far i know its no 3306.

DB Back-up SSH || Forum
when i backed up dB using SSH db is for exmaple 50 MB

Code:

mysqldump -u zodehala -p123 db > backup/vb.sql

but if i use vBulletin its interface to back up db is for example 80 MB
What is the difference between them ?
what is technical explain ?

MySQL For My Forum
Hi folks sorry if i post this in the wrong forum i wasn't sure , Anyway im completely new to this so please bare with me, Im with a webhosting company called oneandone in the UK who host my website but they only offer me a maximum MySQL databse size of 100MB so i was wondering if i can and how i would be able to setup my own databse on my own computer Win XP Pro to host my forum myself but i still want my hosting company to host my website

Phpbb Forum
I'm experiencing some problems trying to get my phpbb forum to work with mysql. I'm running the newest version of apache, and php is installed and working, but I'm not quite sure about what I have to do with the MySQL database part to get it working. If anyone knows of any tutorials or anything I would be grateful
Just for reference: I'm a newb when it comes to both php, and MySQL.

Custom Forum
I'm creating my own forum... unfortunately, my sticky script is being quite unpleasant. The sticky is.. sticking to the bottom!Here's my SQL query:Code:

$fQuery = mysql_query("SELECT * FROM `forumtopics` WHERE `forum` = '$f' ORDER BY `sticky` ASC, `timeEdited` DESC LIMIT $limit1, $limit2")
or die(mysql_error());

What's wrong? `sticky` is a boolean column, and `timeEdited is just a number (generated with time()).

I Have Way Too Many Inserts/updates In My Forum
when someone posts a thread theres 2 count queries
2 fetch queries
3 insert queries
and 2 update queries

so my question is, is there a way to do a sort of join query for inserts and updates?

also, has anyone got some mysql musts?
i dont see a mysql tips thread
i think there should be one

Coding A Forum To Read On A CD
I have a fairly large ubb that I would like made available on CD. Is it possible to do this?

One Database For Site And Forum?
I have a site and a forum and I want to use one database for them, so when somebody registers in the site - to be registered automatically in the forum.
Is this possible and if it is - how?

Merge Two Forum Databases?
I have two phpbb2 forums which I would like to integrate into one forum. I've installed a new forum in the location where I would like the merged forums to go. All I need now is a way to get both of the old databases into the new one I made. I've backed up both databases, but everytime I try to import them into the current one I get errors.

I know I barely know what I am doing, so how can I do this correctly? The tables are the same for both databases, so I just need the data in the tables.

Forum Refresh Issues
I pass a few variables through the URL in GET statements, and I have the problem when people press back it gives the screen asking to resend the information. I also get the problem when I post a response and press back and it posts the response again. Is there a simple way to stop this besides writing a script limiting the posts per certain amount of time??

Forum Search Not Working
Trying to find information about character sets, probably a fairly basic question ... but frustrated because the Search option in the forums doesn't work for me either on my Linux/Ubuntu box or on a W2000 PC.

I have cookies enabled for forums.mysql.com on both, but all I get is a blank screen.

Moving Forum That Uses Database
AOn my website that I am busy rebuilding, I have a forum that uses the MySQL database. The current path of the forum is this:

ingwaz.nl/main/ingwaz.nl/berichtenbord/mercuryboard/index.php

Which is obviously way too long, blame it to inexperience when it comes to designing websites :rolleyes: I want the path to become this:

ingwaz.nl/main/berichtenbord/index.php

The question is, can I move the forum from one folder to another without problems or is this going to mess up the linking with the tables in the database?

Forum Code Using MySQL/PHP
I am currently working on coding a forum for my website. I am fairly new to this coding stuff so i apologise if if this is something really easy.
The way i have coded the forum so far is that one page will display a list of all the topics within that forum. It also displays the unique ID of that topic. The topic headings are set up as a link which when clicked i want it to search the database for all the replies that link to that topic. I have linked the replies to the topics using simply the topic ID.
The problem i am having is i cant work out how to pass the ID variable along in my link, or how to code the link so it will find the replies for that particular topic.
Maybe i have gone about it all totally wrong and need to start from scratch.

Forum (IPS Driver Error)
Whenever i go to send a PM in my invision forum the following error comes up,

Quote: mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM forummembers m, forumgroups g
LEFT JOIN forummember_extra me ON (m.id=me.id)
WHERE LOWER(m.members_display_name) IN ('jabski')
AND m.mgroup=g.g_id

SQL error: Unknown column 'm.id' in 'on clause'
SQL error code:
Date: Thursday 19th 2006f January 2006 08:53:58 PM

any idea what this is, i have reinstalled the forum twice and refreshed the database twice

Forum Related Table Structure
I didn't know whether to post this in the php forum or mysql--we'll try this one:

Suppose that I have a mysql-php based forum running. Users table (simplified) looks like:

Users
------------
user_id (int, primary_key)
username (varchar(30))
password (varchar(30))
read_post_ids (text)

Currently, 'read_post_ids' is a comma-separated list of all the post ids that a user has clicked on, which are marked as such.
Currently a php script is resposible for reading the list into an array, looping through to find values if needed, and on a write back to the db it takes the array and turns it back into a CSV string.

Problem: The table isn't even in 1NF because of this field, and extra processing is going on. As an alternative, I have considered dropping 'read_post_ids' from this table, and starting a new table:

Read_Post_Ids
-------------
id
read_post_id
user_id

This normals the tables and makes queries easier, but I worry about storage. Let's say I have 10,000 forum users, that on average read 20 posts per day. that is 200,000 table rows per day. In a year, I have 71,000,000 rows. If I index the fields (as I probably should for speed), the rows take up even more room. If I decide to only allow a user a maximum of 300 stored 'read posts' (for example), then I probably have to add a timestamp field so I can delete the older ids, which takes up even more space.

So is there a preferred method here? I would prefer that the tables be normaled, but I worry about the table growing out of hand in terms of size, and at some point becoming slow.

Corrupt Text After Moving Forum
hello i just moved my vbulletin forum to another server, but the forum is in spanish and after moving all the database the special spanish characters are corrupted in all the forum, for example instead of

Quote:

TamaÃ±o mÃ¡ximo para subir archivos

Quote:

TamaÃƒÂ±o mÃƒÂ¡ximo para subir archivos

the new server is 4.1.20 and the old one is 4.1.14, theres any way i could solve this?

Sample Schema For A Discussion Forum
I'm trying to design tables for a discussion forum on my website. I'm looking for a sample schema to start with.

Forum Database Merging Question
I am very new to databases although I have backed up, and imported several forum db's using BigDump. That's as far as my knowledge goes i'm afraid.

I have two similar smf forum dumps which I would like to merge into one database. If you imagine and old forum added to a new forum, or two different forums that decide to merge all their boards, posts and members into one.

I have spent some time now reading up on sql, searching for scripts and creating databases in an attempt to get this to work. As I have said, I am a real novice at this kind of thing and would really appreciate some help.

Basically a script would be a dream come true, but I have yet to find one. I am prepaired to read, learn and experiment if somebody could just point me in the right direction. Lastly, if this has been achieved before, a link to a guide or howto would be amazing.

Auto Close Forum Posts
Need help writing a query that checks the date a particular forum post was posted, compares it with the current date. If there is a difference of 30 days, the forum post should be closed.

The database table is called "Discussions"
The "DateCreated" Field of a particular post is Datetime type in the form 2007-04-12 09:21:46

Compare this date of every post with current date, if more than 30 days have passed, then add a 1 to the "Closed" field.

Can I Recover My Forum Database From Ibdata1
Deleted my account in cpanel and lost all the database.. I looked around on my server and found a file called ibdata1 172mb's

This was about the size of my db so im guessing it has somthing to do with it!

Anyone know much about these files and if i might be able to, restore my forum some way with it?

Combining A Chat & Forum Database
But how would I combine a chat and forum so that if one registered for one of them then they would register for both? Basically how would I make a database allowing someone access to any part of the site?

Php Mysql Comments/forum Layout
i ve made a script where php INSERT's data into a table. a table which has "poster" "comment". could anyone please tell me how to echo these results starting from the newest to the last result? use the same kind of layout as a forum if that helps.. o and has timestamps got any use in this?

Forum Outta Mysql Space
my forum (vbulletin) is currently not connected a database because my hosting says ive used 150 megs outta the 100 allowed and theres no way to increase the space.

i was wondering if it is normal to for forums to use that much space? i have about 7,500 users 80k posts. i dont know what to do, is it normal for a forum to use that much mysql space and would anyone know of a good realiable host for mysql hosting because i might have to change servers.

How Do I Change The Date Of A Post On My Forum Site?
Hi, I have started a forum site with a couple of friends. The forum runs on xoops using php 4 with a mysql (4) database. I accidently deleted a few posts. No problem there because I had a copy of the text and posted it again. But the problem is the date and time - obviously it shows the date of the new post and not the date of the deleted one. As I am a newbie still experimenting with mysql and php, I'd sure appreciate your help.

Summary:
=======
I need to change the date of a post in the mysql database. I access the database using phpmyadmin.

How Do I Extract All My Text Data Input From A Php Forum?
I manage a small website using phpbb on a Solaris platform, using mysql 4.x. After being repeatedly hacked, I'd like to migrate to a less singled out forum bb, but without losing my data--most of which is in Chinese characters (so doing string searches is definitely out).

I have direct file access via ftp to the server, and i've also downloaded the corrupted files, only two of which have been modified by the hacker, namely,

phpbb_config.ISD
phpbb_forums.ISD

Unfortunately, the last previous backup the hosting company performed was some 8 months before...

Moving A Forum (phpbb2) With Apache And MySQL
I was wondering if there was a tutorial for moving a complete server from one PC to another and have it exactly like it was, besides IP's exc exc. If you could give me a few steps to back up all my stuff in MySQL and PHPBB it would answer my question.

Two Sites Using The Same Forum Database User List
I know it's possible for TWO different sites to use the same database. Let me explain.

I have siteA and it runs a forum. Through the site, users of the forum can login using their forum ID. I now create siteB on a different domain, but on the same hosting service. I want users from siteA to be able to login with their name from that site on siteB. How would I do this? I'm using myBB as my forum software.

Grab 'title' From The Table 'forum' Within The Same Query (was "Help With Query")
I have the following query for my vBulletin database:
PHP

$get_stats_newthreads = $db->query_read(" SELECT thread.forumid, thread.postuserid, thread.postusername, thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.iconid, thread.views, IF(views<=replycount, replycount+1, views) AS views, thread.visible FROM " . TABLE_PREFIX . "thread AS thread WHERE NOT ISNULL(thread.threadid) AND $weekold<lastpost AND thread.visible!=0 AND (forumid=34 OR forumid=7 OR forumid=8 OR forumid=11 OR forumid=10) ORDER BY rand() DESC LIMIT 5");

and would like to grab 'title' from the table 'forum' where forum.forumid=thread.forumid

Duplicate Key
I'm trying to create a new table that will store a name in various languages. When I run the following, I get a "Duplicate entry '1' for key 1 " error.

I understand that it is because the language ID is the same for the first two inserts, but I don't see how to get around that. Can someone please tell me if the table is setup incorrectly or explain what I need to do to get this to work?

DROP TABLE IF EXISTS header;
CREATE TABLE header (
page_name varchar(64) NULL,
language_id int DEFAULT '1' NOT NULL,
PRIMARY KEY (language_id)
) TYPE=MyISAM;

INSERT INTO `header` ( `page_name` , `language_id` ) VALUES ('index', '1');
INSERT INTO `header` ( `page_name` , `language_id` ) VALUES ('product', '1');
INSERT INTO `header` ( `page_name` , `language_id` ) VALUES ('product', '2');

ON DUPLICATE KEY
i have finally got on query working, but it does with "40 rows affected" !! There are only 17 records in my totals table, and in this case only one record gets updated. So two queries would have:

"INSERT IGNORE..." - only 17 to compare.
"UPDATE WHERE..." - only 1 record updated.

INSERT INTO v8totals (tid,tyy,tmm,prices)
SELECT owners,2007,05,SUM(finalprice) FROM v8x200705 GROUP BY owners
ON DUPLICATE KEY UPDATE prices=(SELECT SUM(finalprice) FROM v8x200705 WHERE tid=owners GROUP BY owners);

So either i have written my query badly (and i tried many ways) or this ON DUP UPDATE is very inefficient.

ON DUPLICATE KEY
following common query:

INSERT ...
ON DUPLICATE KEY
UPDATE ...

Is there more to the UPDATE query than just "UPDATE set a = 'b', x = 'y;" ? I am trying to get the UPDATE query to perform a REGEXP comparison on a field in the table before updating it...something like this:

INSERT ...
ON DUPLICATE KEY
IF (x REGEXP 'y' = 1)
THEN
UPDATE ....
ELSE
UPDATE ....
END

Is this sort of thing impossible?

Not Really A Duplicate
I have a table with 3 fields
Directory varchar(10)
Server varchar(10)
File_Name varchar(10) UNIQUE

I set file_name as a primary key because I thought it would be a unique field to ignore all duplicates. below is an example of my data

Directory Server File_Name

abcd svra testfile
abcd svra testfile
abcd svra testfile
efgh svrb testfile

My data is loaded into the database by a comma seperated file.

I perfrom the following command
load data infile 'svrfiles' ignore into table svr_stuff FIELDS TERMINATED BY ',';

it loads the first entry, ignores the rest. I need it to load the 4th entry. removing the ignore statement gives me a dup error.

if I did not ignore duplicates there would be a 1000 rows of data that I do not want to see.