Autopia Detailer's Directory

http://autopia.org/directory/Coronado-Executive-Detailing/products-all.html



(The link in your post)



Has a fatal mysql error.



( Fatal error: mysql error: [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 '' at line 1] in EXECUTE("SELECT * FROM pmd_offers WHERE firmselector=NULL ORDER BY num LIMIT ") in /var/www/vhosts/autopia.org/httpdocs/directory/includes/adodblite/adodb-errorhandler.inc.php on line 77 )
 
YIKES!!! :wall :idea





PaPaHoFF said:
http://autopia.org/directory/Coronado-Executive-Detailing/products-all.html



(The link in your post)



Has a fatal mysql error.



( Fatal error: mysql error: [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 '' at line 1] in EXECUTE("SELECT * FROM pmd_offers WHERE firmselector=NULL ORDER BY num LIMIT ") in /var/www/vhosts/autopia.org/httpdocs/directory/includes/adodblite/adodb-errorhandler.inc.php on line 77 )
Click to expand...
 
First off...........thanks for doing this David!



Next, where will the directory link be on the home page of autopia? I assume you wont have to be registered to view this directory?



Cheers,

GREG
 
Greg Nichols said:
First off...........thanks for doing this David!



Next, where will the directory link be on the home page of autopia? I assume you wont have to be registered to view this directory?



Cheers,

GREG
Click to expand...





Greg,



Great questions.



I'm creating a new module now that will export listings and products to the home page and other pages (undecided what "other pages" will be at this point. So, the directory will get lots of exposure. Plus, I'm looking at the idea of profit sharing with other forum owners for running our directory ads on their site.



When I go live with this new product, it will be in the main navigation in the header. I am also planning a widget on the home page called "Find A Detailer" that will allow people to enter their zip code and be shown a list of detailers in their area (by zip code radius search).



I'm building a list of more than 1,000 professional detailers that I will announce the new system to. So, I think I gave the current Autopia detailers a nice little bonus with the free upgrade. My hope is that you all will return the favor by creating good looking ads. Rest assured, if I bring the clients and they see a crap ad next to a nice one... they will not be calling the crap ad.



Perhaps I made a mistake giving these ads away because something free has no value. Sure seems that way as very few of the free listings have even so much as a logo or a picture of the detailer's work.



Let me drop you pros a blunt hint... Autopia.org gets 95,000 unique visitors to its home page a month. Very few of those people are regulars (ratio of about 8:1). To give you a ref point, the Meguiars.com web site gets fewer than 35,000 unique visitors per month.



db
 
DavidB said:
Perhaps I made a mistake giving these ads away because something free has no value. Sure seems that way as very few of the free listings have even so much as a logo or a picture of the detailer's work.
Click to expand...



I think a number of other member's are waiting for the system to be 'near launch' to spruce up our ads. I know I am.
 
DavidB said:
Perhaps I made a mistake giving these ads away because something free has no value. Sure seems that way as very few of the free listings have even so much as a logo or a picture of the detailer's work.



Let me drop you pros a blunt hint... Autopia.org gets 95,000 unique visitors to its home page a month. Very few of those people are regulars (ratio of about 8:1). To give you a ref point, the Meguiars.com web site gets fewer than 35,000 unique visitors per month.



db
Click to expand...



Hmmm....I appreciate it, David. :clap:



I have a logo but no detailed photos yet. Easy fix, I suppose.
 
Mindflux said:
I think myself and a number of other entries are waiting for the system to be 'near launch' to spruce up our ads. I know I am.
Click to expand...



Nothing will change with the database format. You won't loose anything you add today.

Launch day is Monday. I'm going to power through to get this thing finished.
 
DavidB said:
Greg,



Great questions.



I'm creating a new module now that will export listings and products to the home page and other pages (undecided what "other pages" will be at this point. So, the directory will get lots of exposure. Plus, I'm looking at the idea of profit sharing with other forum owners for running our directory ads on their site.



When I go live with this new product, it will be in the main navigation in the header. I am also planning a widget on the home page called "Find A Detailer" that will allow people to enter their zip code and be shown a list of detailers in their area (by zip code radius search).



I'm building a list of more than 1,000 professional detailers that I will announce the new system to. So, I think I gave the current Autopia detailers a nice little bonus with the free upgrade. My hope is that you all will return the favor by creating good looking ads. Rest assured, if I bring the clients and they see a crap ad next to a nice one... they will not be calling the crap ad.



Perhaps I made a mistake giving these ads away because something free has no value. Sure seems that way as very few of the free listings have even so much as a logo or a picture of the detailer's work.



Let me drop you pros a blunt hint... Autopia.org gets 95,000 unique visitors to its home page a month. Very few of those people are regulars (ratio of about 8:1). To give you a ref point, the Meguiars.com web site gets fewer than 35,000 unique visitors per month.



db
Click to expand...



David, not sure if I can link this here but I am just looking to see if you had any other advice. I have used just about every character I am allowed and I tested to see if I could throw some CSS in there (you cant).



Car Detailing & Svc. | Automotive Detailing Centers | DoubleTake | Autopia Directory



I need to make a PDF flyer of our services before I can add that and post some of our after pics.



I doubt I can use img tags can i?



edit: nope no img tags, I don't want to try and break anything else to make my ad stand out.



Also, the silver package doesn't allow any images so I could only add an image in the product section.
 
DavidB said:
Nothing will change with the database format. You won't loose anything you add today.

Launch day is Monday. I'm going to power through to get this thing finished.
Click to expand...



ahh. Well then it's time to get a few pictures read.

:sign
 
2k2blackWRX said:
David, not sure if I can link this here but I am just looking to see if you had any other advice. I have used just about every character I am allowed and I tested to see if I could throw some CSS in there (you cant).



Car Detailing & Svc. | Automotive Detailing Centers | DoubleTake | Autopia Directory



I need to make a PDF flyer of our services before I can add that and post some of our after pics.



I doubt I can use img tags can i?



edit: nope no img tags, I don't want to try and break anything else to make my ad stand out.



Also, the silver package doesn't allow any images so I could only add an image in the product section.
Click to expand...



Allowing you to add CSS or any advanced HTML would be paramount to me turning over my website look and feel to you. It is simply too risky, and frankly, allowing too much freedom just makes for a junky looking directory.



I'm working on a tabbed template now for content display that I think will make listings look much nicer. I have not decided at what level I will offer the new tabbed template (Platinum for sure).



db
 
Ive tried to add an image but I click on edit my listing and it wont go back to where i need to add the image! It will only let me edit my name and location!

I was on my laptop when i created the account and my documents are on my home computer so i had to wait till i got home to add the pics/logo etc! I wanted to try and get in the 50 first so i can get a silver membership so i just put in the basics and figured once i got home id add the rest! Any tips on how to edit my listing??



EDIT::: there is an EDIT/VIEW link in the blue bar i clicked that and got to add pics!!:woohoo:
 
I can't believe I didn't notice this thread until now. :eek:



I've uploaded my information, not sure when I will get an e-mail link though, my old website host for some reason has my old site still up and depending on which server I hit when I open outlook, I either get my e-mail or get an error message. Just letting you know so you don't think I am ignoring the activation. ;)



Let me know when the directory is fully ready, I moderate the detailing forum on a website that has around 200,000 members with 70,000 active the last 30 days. I get asked all the time for recommendations for detailers all over the country and unless I have someone in that area in the directory I have in the detailing forum, I don't know where to send them.
 
David, I have found two bugs:



1. When logging in initially I have to go through the following steps:



Login Screen->Click Login->See Listing Screen-> Click View/Edit Listing -> Back to Login Screen -> Back to View Edit Screen ->Finally able to edit



2. When adding an image to the products page, I have a 500x500 image that is around 50kb and it wont allow me to add the image to my listing.



The regular images work great!
 
You must log in or register to reply here.
Back
Top