metiqolman

OK! I figured out what was going on.
In my case the database wouldn’t update for two reasons.

The first issue was that the database I was exporting from my local machine was in the wrong format. When exporting a database from PHPMYADMIN you need to have the format set to SQL.

The second issue I ran into after THAT was that the database that was created on the hosting server would not allow me to upload my information to it. Still investigating why.
I ended up deleting all the tables from in the DB on my host. Then I imported the custom tables and the site started running immediately. YEAH! Thanks everyone for your help.

Yeah… that’s kinda what I thought as well. I’m gonna copy my file to a new name and try that.

I’ve got some people at my host service working on the issue. Funny thing is that when I exported the database FROM my hosting service they file I got from them was the same way. Maybe it’s the MAC text editor dropping that in there… don’t see why though. I’ll replacing the character and post what I find out.

OK.. this information is pretty straightforward and I’ve followed all the steps very carefully.

Upon uploading the database file it tells me that there’s a problem and then essentially lists the entire database with a comment at the end about line 1.

I’m no guru when it comes to reading code so I’ll paste below what the server is responding with:

This is at the top of the report:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: ==
SQL: == Database proph006_wordpress1

|——
|Field|Type|Null|Default
|——
|//**comment_ID**//|bigint(20) |No|
|comment_post_ID|bigint(20) |No|0

This is at the bottom of the report:

MySQL said: Documentation
#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 ‘== Database proph006_wordpress1

|——
|Field|Type|Null|Default
|——
|//|’ at line 1

Any help will be greatly appreciated.

RVoodoo… I really have to apologize. I read thru the documentation and I must have really missed it / dropped the ball. Concerning the index.php… disregard that. I think I was sent down the wrong path by someone else.

I did not understand that I needed to “create” a mysql data base at my host. I thought I had followed the instructions closely but totally screwed that up.

I have since went to my hosting service, starting from scratch, and created a database, then a fresh install of WordPress as well. Logged in and finished the install so now I have the dashboard and all the tools at my host. DONE.

You have the theme index.php renamed? Or the root index.php?

As for the theme index: I have not renamed it or the root index.php. Again… I think I either misunderstood or was lead down the wrong path.

do you have your mysql stuff from your local setup moved to your host?

No. I’ve created a database but I have not uploaded anything to it. I don’t know how as of yet but am tying to figure it out.

So that’s where I’m at right now. The database is there and the installed default wordpress site is up. Now I just need to get my stuff up there.
The site is https://www.propheticflow.org

I’ll be out for a bit and will check back later. Your assistance is greatly appreciated.

No… I’m using Word Press installed locally on my machine to produce my website. This way I can look for and correct any mistakes prior to making it public. I guess I should have clarified that. But thank you for your insights. So let me explain in detail.

I installed WP on my machine locally. Downloaded several different themes to test them out and see how they would look. Selected the one I wanted and built my site. (All locally)

I installed the script at omnis.com, accepting all the defaults during the process. (It performed the install of wordpress in a /wp/ sub-directory)
It took me a while to figure out that it was not suppose to be installed there.(in the WP directory) So… I went back and uninstalled and reinstalled it (again accepting all the defaults) and this time it placed everything in the correct folder.

Then I uploaded my theme that is under the local wp-content folder to the ‘themes’ directory at my host.
Renamed the index.php to index.php_default.
This is where I am stuck. I don’t see MY page. All I see is the ‘Hello World’ blog page. Not the site I’ve built.

I’ve been looking over much of the forums and have started looking thru the documentation. Typically I can pick this kind of stuff right up but I’m struggling a bit here with this.

Ok I’ll get them back in place.

What I don’t understand is why my site (on my local machine) works great but when I uploaded the content to the ‘Themes’ directory I’m not seeing anything.

I’ve searched hi and low for instructions on uploading your page once it’s completed and can’t find any.

I’m a newbie with the whole wordpress/php site building software so any help is greatly appreciated.

Hi,
I’m having the same trouble with the two home pages…..
I’ve followed the instructions from this thread but have not been able to resolve this.
I’ve tried finding the code listed above:
” Find the area in your theme that has..
wp_list_pages()
NOTE: Most likely header.php

Copy and paste the code from about 4 lines above to about 4 lines below where you find wp_list_pages here (inside backticks – or use a pastebin / “

When I search the header.php file I don’t find this information.
Help???

Greg

Well… shonnalemke…
I don’t know what to say… but THANKS!
I followed the instructions in your link and mine is finally working…
The ONLY thing thats different is the step where he states “test if it is working by opening your browser and going to https://localhost:8888/ You should see the contents of your ~/Sites “
I was always putting in https://localhost:8888/~username/’wordpress folder name’/wp-admin/install.php

This time I just put in https://localhost:8888/ and it found the install.php and started the dialogue.
Now I just hope it keeps running. ??
Thanks for everyones help!
Greg

I think I might to… my only question is where do I start over from?
Do i just delete the folders with MAMP and WordPress and start from scratch?

Songdotech,
I’ll check that out and let you know. I tried installing WordPress on my G5 using the method you described and didn’t get very far with that at all. Although with the knowledge that I’ve acquired in the last day I might go back to that machine and try again. I’ll check the .htaccess permissions and let you know.

I know what you mean shonnalemke. It can be very confusing when you watch someone else get it working but it just won’t for you! ??

yeah.. I’ve already got that installed.

Are you familiar with the MAMP application?

I installed that and created a data base thru that. It has PHPMyAdmin built right into it.

I’ll delete the data bases and start over and see if anything changes. Actually I’m probably going to start right from the beginning and walk thru the steps again.

Yup… PHP is running…

Yeah… that’s what it looks like.
But all the files that I see in the browser look like links.

In any case I did everything described in ‘Enabling PHP in Mac OS X 10.5.
The changes did need to be made but I’m a bit confused as to why. It was my understanding that the MAMP install and config would cover all this… I guess not.

I’ve made all the changes and stopped and started my servers. Put this in my URL
https://localhost/~administrator/wordpress/wp-admin/install.php and it continues to open up the install.php in text format instead of the Word Press install dialogue.

Ok.
Personal web sharing is on in my preferences pane.

I had placed the word press folder in the htdocs directory per some instructions I received. I moved that info to my ‘sites’ folder and am now able to see an index of all the files and folders.
Now when I open up the install.php it shows us as a text document rather than starting the install.

Still working on it… getting closer but not there yet! ??

This is what I put in the URL

https://localhost:8888/wordpress/wp-admin/install.php