Printable View
Hello,
I was just wondering what any of you people(:D) do with your website and the news stuff. Like, when you put news on your site, do you do it manual or have some news script or something?? I am in search of a program that puts news on my website... (FREE)
I've had this done before(lost it)... an ASP page that you can send info to (but if someone finds out the parameters, ouch you got a site full of ads probably)
Thanks,
alacritous
I use a php script that generates my index page and as it does that it makes a querry to my DB and this has a News table which it basically displays all the records in Date order and I have a priority system which handles if two items are on the same date. It also ignores dates that aren't reached yet so I can add news items that won't appear for X amount of days :D.
Anyone else know an easier way? :D
lol, I would say my way is the easiest you can get apart from editing the html each time you update. At least this way it all looks after itself once I coded it once, so to add a new item it takes a couple of seconds to add a DB record. :p
I understand that, but if I can't get phpBB to work... then why make a database? and do all that... Could you help me get phpBB to work? lol...
Whats the prob with phpBB? Its that bad to use, have you got it installed already?
phpBB2 is it?
funny that you ask...
well anyway, it keeps saying the database isnt created (i dont know crap about mysql) so i download myphpadmin (which creates databases) and it still doesn't make one.. its all messed up.. i can try to install it again, but in the end it just caused too much crap.
Sorry but the way I remember it is you uplaod all the files to the server and then run install.php it then asks some options then it creates the DB for you. Cos you can't do it your self without knowing the structure of all the tables ;).
I run the install.php, thats when it has the error. I'll try it again though.. maybe my other computer has problems...:PQuote:
Originally posted by Electroman
Sorry but the way I remember it is you uplaod all the files to the server and then run install.php it then asks some options then it creates the DB for you. Cos you can't do it your self without knowing the structure of all the tables ;).
Oh Yes... When I run the install.php, I don't know what to put for the database name..... if it creates wahtever you type, then why do I get an error?
EDIT: You do need a database, just nothing in it... And I need to create a MySQL database...Quote:
phpBB : Critical Error
Could not connect to the database
Can anyone possibly help me? I know its VBFOrums, although ChitChat, but I tried posting in the PhpBB and they are real mean people.. LOL.. anyone installed this? how?
Are you using a hosting plan or your own server? Normally they have a option in the control pannel of hosting plans to create a new DB. I don't think phpMyAdmin can create the DBs only connect to them :unsure: at least my host won't give me access to create DBs my self.
Own Server...I installed everything that is required... (PHP, etc)
Did you manage to create DB at all? Like is it just not recognising it or can't you create it?
phpMyAdmin can definately create, edit, drop etc. databases. I use it all the time on my PC.
Your not thinking about tables are you? Or does it do both?Quote:
Posted by Acidic
phpMyAdmin can definately create, edit, drop etc. databases. I use it all the time on my PC.
Hello,
If you can create one, can you give me one? I need a damn database for the forums, and I don't know CRAP about creating one. I tried using MyPhpAdmin and it doesn't do crap for me....
Please help!!
alacritous
it does bothQuote:
Originally posted by Electroman
Your not thinking about tables are you? Or does it do both?
Now I am real hyped up.. make me one :D .... when I downloaded it I get errors...Quote:
Originally posted by Acidic
it does both
I've attached my database which Ive used for testing stuff to this message.
edit: unzip it, then import the file into phpMyAdmin through phpMyAdmin itself
hhm. I don't think that file creates the database, only the tables in it. if all else fails to create a DB, do this:
open MSDOS prompt
get to the folder with mysqladmin.exe in it
type: mysqladmin -u root create mydb
type: exit
then open phpMyAdmin and voila, you have a new db there for you, then import the sql file
i think
Ugh...
Have you done this for PhpBB? It creates the tables for you, I suppose. But you need the database...
For phpBB all you nee is an empty Database and when running the install.php for it you tell it the name of the blank database ;).
Yes... I need help creating it... I was asking if Acidic made a blank database... I'm sorry for all the trouble, I am a complete newb at databases... And I don't feel like having the choice in my head to kill myself because I can't make an SQL Databse : \
Here you go, I opened my phpMyAdmin and on the page after loging in it shows this:
http://www.vbforums.com/attachment.p...postid=1731982
The account I logged in as doesn't have access to add new Databases but the bit I circled is where you should find the option ;).
Ugh... See when I try PhpMyAdmin, it has an error, again...
I'm so pissed....
....and the error is??
i had a problem like this turns out you need to check the config file for phpmyadmin.
make sure that the server port for mysql matches as well as the user (normally root).
Lets do this by step...
http://www.phpmyadmin.net/documentation/
Installation
Quick Install
1. did
2. ""host" means the MySQL server"
*** sql server? im running my own server so do i need this?
stuck...
alacritous
try this:
open MSDOS prompt
get to the folder with mysqladmin.exe in it
type: mysqladmin -u root create mydb
type: exit
Then make it localhost. 128.0.0.1 (thats right?)Quote:
Posted by alacritous
Lets do this by step...
http://www.phpmyadmin.net/documentation/
Installation
Quick Install
1. did
2. *** sql server? im running my own server... *** is this?
stuck...
alacritous
isnt it 127.0.0.1 for localhostQuote:
Originally posted by Electroman
Then make it localhost. 128.0.0.1 (thats right?)
When I do 127.0.0.1 for host (its 7, not 8)
Quote:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#2003 - Can't connect to MySQL server on '127.0.0.1' (10061)
[Documentation]
that's itQuote:
Originally posted by señorbadger
isnt it 127.0.0.1 for localhost
change the port to 3306
like this localhost:3306
this was the issue on my laptop
Doh, and I was thinking it was either 126 or 128 :rolleyes: :(.
If making it use port 3306 doesn't work then make sure that the mysql server program is running ;).
lol... see I told you I don't know databases... How do I run the mysql server?Quote:
Originally posted by Electroman
Doh, and I was thinking it was either 126 or 128 :rolleyes: :(.
If making it use port 3306 doesn't work then make sure that the mysql server program is running ;).
Also, what do I put for the other stuff like username and all that? Because I don't have a database so how do I know?
...
And YES, I did install it :P
username should be root
no password by default
Yea but he wants to change them before he sets everything up. otherwise it'll be the easiest server to be hacked ever ;)Quote:
Posted by señorbadger
username should be root
no password by default
I don't really care anymore... or right now... I just want to set up my damn forums... So how do I run the server? mysql server?
start > run > services.msc
look for mysql
make sure its started if not start it
Thats the whole point.. I asked how to start it...
(there is no exe...do i need to download something else?
go into c:\mysql\bin and click mysql and it should load up, if not just click all of them till you find the right one :D
this is why i quit installing it a little while ago...
well anyway, heres the error after opening mysql.exe in c:\mysql\bin
Quote:
C:\mysql\bin>mysql.exe
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
Hmm, found something interesting...
I ran MySQLAdmin and it has a database.. im trying it right now
whalah... got phpmyadmin to run
**** yeah :P
http://24.98.100.220:8000/phpBB2/
temporarily though, i don't think the database has a password
yeah you really gotta sort the Db username and password out, I've never ran mysql my self so I don't know how you do that :(. Thing is then you'll have to alter the phpBB to reflect the changes.
the URL doesn't work, the directory doesn't exist. the server is running though, if I remove phpBB2/, then it works fine.Quote:
Originally posted by alacritous
http://24.98.100.220:8000/phpBB2/
temporarily though, i don't think the database has a password
edit: now it works.
ugh.. (post got messed, ill retype)
thats because i was trying to upload it to my comcast account, but it won't allow the file .htaccess due to the "."....
soon ill be able to run it 24/7 by getting another computer
WOHOO, I posted in it
everyone, get a username :D
first, get a username and password for phpMyAdmin. Anyone can walk in and look at your tables.
Sure phpBB encrypts the passwords, but still. Do it now so you don't have to do it later.
I am at the admin thing.. what do I do?
Also, I was just wondering how I would create a news type thing...
If you goto Stealthbot.net it will have news, then if you click on it, it goes to a forum. Anyone know if PhpBB2 has this?
EDIT - might have this - EDIT2 - or not
im STILL stuck on the password, though
dont know. never done it. my phpMyAdmin is only on my localhost, so I never bother with a password.
i might have created one..
anyone know how?
Ok... I did create one because if I change password to blank it doesn't work.. ALTHOUGH.. when I use phpmyadmin it doesn't work, even with the right password..