Antworten: 12
Seite [1] |
|
 BeatleBeginner  Beiträge: 5 |
# Thema - 28.04.2010 um 00:20 Uhr
I have uploaded everything, and made it through most of the install steps but, when I click on "Create" on step 6 to setup the admin user I get an error message that says> "An important sql query failed due to the following problem: -------------------------------------------------- ------------------------------ Table 'usrw8_clansphere.usrcs_options' does not exist " I went to the database using phpMyAdmin, and I noticed there are no tables in the Database. I tried to create the tables using the sql file (install.sql) but I get an error message from that too. The error message I get from the sql query says> [Php] SQL query: CREATE TABLE (pre) _abcode ( abcode_id (serial) abcode_func varchar (8) NOT NULL default'', abcode_pattern varchar (40) NOT NULL default'', abcode_result varchar (40) NOT NULL default'', varchar abcode_file (80) NOT NULL default'', PRIMARY KEY (abcode_id) ) (ENGINE); MySQL said: # 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 '(pre) _abcode ( abcode_id (serial) abcode_func varchar (8) NOT NULL default 'at line 1 [/ php] So, I am stuck. I really want to use your script for our clan (http://TheUSR.com) but I can not seem to get it installed. I would really appreciate any help you can offer. Also, I own / operate a web hosting company called http://AHostingWeb.com, and have for 6 years now. If I can get this working, I would be happy to donate some disc space and bandwidth to host clan sites that use this script, or host any files you may need space for? Thanks in advance! ------------------ http://AHostingWeb.com • Affordable Clan Website Hosting http://W-8.us • Free Link Shrinking & Cloaking http://FreePhotoUpload.info • Free Photo Hosting http://TheUSR.com • Elite Gaming Clan http://DomainNameWhois.info • Free Domain & SEO Tools http://TodaysHits.info • Free MP3 Search & Downloads |
Inaktiv |
 |
 hajo  VIP - Poster  Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 1 - 28.04.2010 um 00:29 Uhr
clansphere uses placeholders in sql statements that are parsed and replaced before the query gets executed. so phpmyadmin and other tools are not capable for a manual installation of clansphere. possible solutions: - replace all placeholders inside the sql file, could take a while and i don't recommend this for users not familar with the internal structure of clansphere - activate the error logging inside the setup.php file, restart the installation and look inside /uploads/logs/errors for new files named like an iso formated date and show that information here so that we can try to help - provide additional information e.g. the selected php sql extension, php and sql server version etc. so that we can guess a bit what may cause that problem ------------------ ClanSphere - professional clan care starts here Zuletzt editiert von hajo am 28.04.2010 um 00:30 Uhr (1x Editiert) |
Offline |
|  |
| Beatle Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 2 - 28.04.2010 um 00:47 Uhr
First of all, let me say think you for your fast response! 1. I can edit all instances of any symbol, word, or phrase with one click using Crimson Editor, so that might be an easier solution that you may think. I just need to know what you are referring to when you say "PlaceHolders". 2. I just looked in the files and I don't see a setup.php file anywhere. Can you tell me where that might be located? 3. Not sure what you mean about php sql extention. PHP version 5.2.12 MySQL version 5.0.89-community Operating system Linux Kernel version 2.6.30.5 cPanel Version 11.25.0-RELEASE Apache version 2.2.14 Please let me know if you need any further info and I will be glad to list it. Thanks again! ------------------ http://AHostingWeb.com • Affordable Clan Website Hosting http://W-8.us • Free Link Shrinking & Cloaking http://FreePhotoUpload.info • Free Photo Hosting http://TheUSR.com • Elite Gaming Clan http://DomainNameWhois.info • Free Domain & SEO Tools http://TodaysHits.info • Free MP3 Search & Downloads |
Inaktiv |
| |
| hajo VIP - Poster Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 3 - 28.04.2010 um 00:55 Uhr
3. Not sure what you mean about php sql extention. there was a dropdown to select a database extension that connects php with the sql database (mysql in this case). for mysql this can be one of the following: mysql, mysqli, pdo_mysql 2. I just looked in the files and I don't see a setup.php file anywhere. Can you tell me where that might be located? on top of the dir structure where the index.php and dirs like symbols, system etc. are located that belong to your clansphere installation 1. I can edit all instances of any symbol, word, or phrase with one click using Crimson Editor, so that might be an easier solution that you may think. I just need to know what you are referring to when you say "PlaceHolders". placeholders start with { and end at }. they make it possible to use one *.sql file for various rdbms like e.g. postgresql, sqlite, microsoft sql server, etc. if you want to replace them i can try to provide a list of expressions, but this is - in my thoughts - the very worst option to install clansphere at all 
------------------ ClanSphere - professional clan care starts here Zuletzt editiert von hajo am 28.04.2010 um 00:57 Uhr (3x Editiert) |
Offline |
| |
| Beatle Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 4 - 28.04.2010 um 04:03 Uhr
It was mysql, I'm sure of that. I've looked in the root of the script files (where the index.php is), and there is no setup.php file anywhere. I just checked the sql file and there is only one "at" symbol (@). It's at line 800 in "noreply (at) yourdomain (dot) com". So, I don't know what to do about that. I could offer someone a free CPanel reseller hosting account if they can get this installed and running for me? If you're interested in the deal, let me know by PM'ing me here, or emailing me at admin(AT)ahostingweb(DOT)com. ------------------ http://AHostingWeb.com • Affordable Clan Website Hosting http://W-8.us • Free Link Shrinking & Cloaking http://FreePhotoUpload.info • Free Photo Hosting http://TheUSR.com • Elite Gaming Clan http://DomainNameWhois.info • Free Domain & SEO Tools http://TodaysHits.info • Free MP3 Search & Downloads |
Inaktiv |
| |
| hajo VIP - Poster Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 5 - 28.04.2010 um 04:11 Uhr
have you tried to create the setup.php file manually? the install step for the setup provides a "show" button where you can see the file details and create it by yourself while using the given data i wonder about the fact that you came to step 6 without having a setup.php file, this shouldn't work. are you using the 2009.0.3 version? placeholders look like this: {placeholder} for what reason do you post the at-sign @? do you have icq / msn or something like that for instant messaging? ------------------ ClanSphere - professional clan care starts here Zuletzt editiert von hajo am 28.04.2010 um 04:14 Uhr (1x Editiert) |
Offline |
| |
| Beatle Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 6 - 28.04.2010 um 09:24 Uhr
I'll try to reinstall and check on the setup file and let you know what I find out. I posted the @ symbol due to what you stated above "placeholders start and end with (at).. No, I do not have any IM software but, I can get one if it will help me get this working. Reeally I'm looking forward to getting this working. Just checked and I am using vClanSphere 2009.0.3. Thanks again! EDIT: I just tried to reinstall and I do see the "Show" text but, it's just text, it's not a link at all. I got the same error message "An important sql query failed due to the following problem: -------------------------------------------------------------------------------- Table 'usrw8_clansphere.usrcs_options' doesn't exist " Also, I did find the setup.php file within the script root. ------------------ http://AHostingWeb.com • Affordable Clan Website Hosting http://W-8.us • Free Link Shrinking & Cloaking http://FreePhotoUpload.info • Free Photo Hosting http://TheUSR.com • Elite Gaming Clan http://DomainNameWhois.info • Free Domain & SEO Tools http://TodaysHits.info • Free MP3 Search & Downloads Zuletzt editiert von Beatle am 28.04.2010 um 09:38 Uhr (2x Editiert) |
Inaktiv |
| |
| duRiel Weltmeister  Herkunft: Cambridge Beiträge: 7300 |
# Antwort: 7 - 28.04.2010 um 09:31 Uhr
meet you in irc quakenet channel clansphere? |
Inaktiv |
 | |
| Beatle Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 8 - 28.04.2010 um 09:33 Uhr
Sure but, I've never used irc so I have no idea how to use it or access it  Just tried the "clansphere @ irc" link on the left but it gives a "Page cannot be displayed error. ------------------ http://AHostingWeb.com • Affordable Clan Website Hosting http://W-8.us • Free Link Shrinking & Cloaking http://FreePhotoUpload.info • Free Photo Hosting http://TheUSR.com • Elite Gaming Clan http://DomainNameWhois.info • Free Domain & SEO Tools http://TodaysHits.info • Free MP3 Search & Downloads Zuletzt editiert von Beatle am 28.04.2010 um 09:52 Uhr (3x Editiert) |
Inaktiv |
| |
| duRiel Weltmeister Herkunft: Cambridge Beiträge: 7300 |
# Antwort: 9 - 28.04.2010 um 09:43 Uhr
http://webchat.quakenet.org/ just enter any nickname and the channel clansphere |
Inaktiv |
| |
| Beatle Thread-Ersteller Beginner Beiträge: 5 |
# Antwort: 10 - 28.04.2010 um 09:45 Uhr
Got it installed! Thanks for all ytour help everyone! ------------------ http://AHostingWeb.com • Affordable Clan Website Hosting http://W-8.us • Free Link Shrinking & Cloaking http://FreePhotoUpload.info • Free Photo Hosting http://TheUSR.com • Elite Gaming Clan http://DomainNameWhois.info • Free Domain & SEO Tools http://TodaysHits.info • Free MP3 Search & Downloads Zuletzt editiert von Beatle am 28.04.2010 um 09:52 Uhr (1x Editiert) |
Inaktiv |
| |
| hajo VIP - Poster Herkunft: Barsbüttel Beiträge: 9411 |
# Antwort: 11 - 28.04.2010 um 16:49 Uhr
oh ok you mixed up the @ with my placeholder example, sorry what was the problem like? maybe that helps us to provide a better install experience ------------------ ClanSphere - professional clan care starts here |
Offline |
| |
 IR_BaboonBeginner Beiträge: 1 |
# Antwort: 12 - 07.05.2010 um 13:36 Uhr
can you tell me what was the solution you found to solve the problem? i'm havind the same problem and i can't create the setup.php and when i copy the "show" text to a nem php file, it shows the same error: ""An important sql query failed due to the following problem: -------------------------------------------------- ------------------------------ Table 'a3035081_abs.cs_options' does not exist" and sometimes, after changing files permission, it shows: " DB Error: Access denied for user 'a3035081_abs' (at) '10 (dot) 50 (dot) 0 (dot) 37' (using password: YES)" |
Inaktiv |
| |
Antworten: 12
Seite [1] |
|
| Sie müssen sich registrieren, um zu antworten. |
