ddf1230 — Wed, 25 Jan 2006 00:40:45 +0000

If it's a blog you want, I'd recommend WordPress

NewTechGuy — Tue, 24 Jan 2006 23:34:33 +0000

Hey,

Thanks again for your help.

I think what I'll do is look for a different script to use. It might be the final key I need since I've done almost everything else. Yeah that's it.... I'm on the hunt again....lol...

Thanks a million....you've been GREAT!

ddf1230 — Tue, 24 Jan 2006 23:08:59 +0000

Ok, that I can't help you with. Might be a question for the developer who gave you the sql code to use. But you've got the procedure down now. Now, it's just a matter of having the right code. Good luck.

NewTechGuy — Tue, 24 Jan 2006 23:04:20 +0000

Okay, so.......you almost had me excited there.....LOL...

But I already tried that..... and just to make sure i tried it again with the code you recommended and believe it or not I got yet another error message....here it is:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
display char(1

Thanks again.....

ddf1230 — Tue, 24 Jan 2006 22:42:30 +0000

Oh, but you are so close. If the box was blank and didn't have a default sql statement in there, that's ok! In that case, just put

CREATE TABLE wfblog (
blog_id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
content text NOT NULL,
published timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
display char(1) default NULL,
PRIMARY KEY (blog_id)
)

into the empty box and hit go. All done!

NewTechGuy — Tue, 24 Jan 2006 22:01:24 +0000

Okay, it's official......I GIVE UP. There is just to much that I don't know, or understand about this.

I did exactly what you said and everything was good until I had to replace the default sql statements with the entire sql statement that the developer supplied. I never had anything like you had that says (SELECT * FROM `word` WHERE 1)... I just have a big empty text box.

On top of that I have no idea what the sql statement would be. To me it could be either this...

blog_id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
content text NOT NULL,
published timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
display char(1) default NULL,
PRIMARY KEY (blog_id)

OR THIS........

I tried both options because I have no idea what I'm doing. The truth is I just don't have the experience to know.

I also don't know if "query" means the same as statement <--- yeppers, just don't know.

You make it sound so easy until I get to where I'm supposed to be and discover things don't look the same or that I just don't understand the terminology.

So....I'm gonna stop. It's too frustrating. But I would like to extend a BIG thank you to you for trying. I appreciate everything you've tried. Thank you so much.

with the entire sql statement that the
developer gave you. Then click on Go. That should set up the table for you
with no further work on your part. Hope that helps.

ddf1230 — Tue, 24 Jan 2006 20:55:46 +0000

Ok, well, I would have gone about it differently, so maybe if you try it the way I would have done it, it will work. First, I'd delete the table you created. Then, i'd start over. Once you select the database from phpmyadmin, look right above the database name, and you should see a little icon that says SQL. Click on that and replace whatever default sql statement that they have there (mine says SELECT * FROM `word` WHERE 1), with the entire sql statement that the developer gave you. Then click on Go. That should set up the table for you with no further work on your part. Hope that helps.

NewTechGuy — Tue, 24 Jan 2006 20:36:19 +0000

Yeah, I knew this stuff was a little "over-my-head" but I thought I'd give it a try. Up to this point I've been able to use phpmyadmin to create a new database however I have been unable to create a table.

I will explain how I attempted to create a table:

After clicking on phpmyadmin I got a new window. From here, I am required to choose a database from a drop-down list in order to continue, and so I did. I chose _blog which is the name of the database I originally created. From there I was transferred to another page.

From this new page I am asked to "Create new table on database global1_blog:" which I have done, and I gave the table the name wfblog (I got that table name from the php script). I am also asked to provide a number for the "Number of fields:" and input that number into a box. Since I have NO IDEA what this means I just enter the number 1 ... then I click on "Go".

I arrive at yet another page, and apparently this is where all my troubles begin.

On this page I have to input a bit of information. When doing so, I've used the information from the script (supplied by the developer and which I included in BOLD, in one of my previous posts above). I'm asked to supply the following information.

Field Type Length/Values* Attributes Null Default** Extra

I am only having a problem with one of these... the "Field"..... I can not input anything at all into the Field area without getting a message like the following:

#1063 - Incorrect column specifier for column 'wfblog'

Now, it doesn't matter what I put into the Field area. Nothing works. If there is something inside the script that is supplied for me by the developer that MUST be put into this area then I am not seeing it, or understanding it. All I know is nothing is acceptable for the Field area! I get the same error message all the time (except for the "wfblog" part at the end of the error message, that will change to whatever I tried to input into the field area) and therefore I am unable to continue on and create the required table . I've tried numbers, different names, and even greek stuff etc... but the Field area won't take any of it.

Oh and one last thing, if I attempt to view the blog using a browser, the browser returns the following error..... Table 'global1_blog.wfblog' doesn't exist. I'm not surprised since there is no table created, I just thought it may help you.

That's about all I've got for now. If it's too much then I'm gonna have to call it a day and quit <----I hate that word.

Once again, thanks for your interest.

ddf1230 — Tue, 24 Jan 2006 18:56:29 +0000

I'm a little lost on what you attempted to do, but if you use phpmyadmin, you should be able to enter the sql code exactly as provided by the script developer and it should work. Perhaps if you tell us how you were attempting to go about creating the table, it would help.

Hostname is correct but...

NewTechGuy — Tue, 24 Jan 2006 16:42:04 +0000

I checked with my hosting provider and the hostname is correct (localhost). I've made progress but am stuck once again. I cannot create the needed table for this project. It won't let me put anything in the FIELD section (box). There must be something that HAS (or can) go into it. Can anyone let me know what I'm supposed to put into this box?

This is the error messsage I get from the server:

CREATE TABLE `wfblog` (

`wfblog` VARCHAR( 255 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `10` )
) TYPE = MYISAM
MySQL said:

#1063 - Incorrect column specifier for column '[B]wfblog' [/B]

And the following is the code I have to work with. It was supplied by the developer of the script. (Maybe someone can see something that I'm missing.)

Here is the SQL syntax for creating the needed table...

Thanks for any further assistance.