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']
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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.
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
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
Duplicate Forum Messages
What is the most efficient way to check if a forum user is posting a message they already posted? Would getting a select count of the number of duped messages be more efficient, or is there a better way?Example: bob posts 'kfafasfas', then tries to post 'kfafasfas' again as a new message, but it's a dupe of the first post.
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?
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
|
TRACKER
