DragonPrime - LoGD Resource Community
Welcome Guest
  • Good morning, Guest.
    Please log in, or register.
  • July 25, 2016, 01:05:50 AM
Home Forums News Links Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
IRC Channels
Search

Pages: [1]   Go Down
  Print  
Author Topic: Weird Home.php  (Read 64513 times)
0 Members and 1 Guest are viewing this topic.
renakh
Guest
« on: November 02, 2005, 12:18:03 AM »

When i installed the game, there was a error in the tables pages...and when i go to login i get a weird page...

http://lotgd.starwarsreality.com/home.php

anyone else seen this?

as for the error it was...

Code:
The tables now have new fields and columns added, I'm going to begin importing data now.
Version 0.9: 204 SQL statements...
Doing: 10... 20... 30... 40... 50... 60... 70... 80... 90... 100... 110... 120... 130... 140... 150... 160... 170... 180... 190... 200...
Error: 'Column count doesn't match value count at row 1' executing 'INSERT INTO lotgd_news VALUES (1,'A strange awakening takes place in the world.',now(), 0, '')'.
204.
Version 0.9.1: 416 SQL statements...
Logged
Kendaer
Guest
« Reply #1 on: November 02, 2005, 07:59:37 AM »

Ahhh.. I see what happened.. Edit the installer, and look for that insert into the news line, and change it to read....

Code:
"INSERT INTO " . db_prefix("news") . " VALUES (1,'`^A strange awakening takes place in the world.`0',now(), 0, '', '')",

(basically adding another '' to the end of it)
Logged
renakh
Guest
« Reply #2 on: November 02, 2005, 12:31:25 PM »

that worked, thanks
Logged
renakh
Guest
« Reply #3 on: November 02, 2005, 01:13:40 PM »

When i try to install new patches tho I get something just like it. I tried to add in some of the stock race and class mods and I get..

Code:

SELECT
         lotgd_module_hooks.modulename,
         lotgd_module_hooks.location,
         lotgd_module_hooks.function,
         lotgd_module_hooks.whenactive
      FROM
         lotgd_module_hooks
      INNER JOIN
         lotgd_modules
      ON   lotgd_modules.modulename = lotgd_module_hooks.modulename
      WHERE
         active = 1
      AND   location IN ('template-header', 'template-footer', 'template-statstart', 'template-stathead', 'template-statrow', 'template-statbuff', 'template-statend', 'template-navhead', 'template-navitem', 'template-petitioncount', 'template-adwrapper', 'template-login', 'template-loginfull', 'everyhit', 'header-home', 'footer-home', 'holiday', 'collapse{', 'collapse-nav{', '}collapse-nav', '}collapse', 'charstats')
      ORDER BY
         lotgd_module_hooks.location,
         lotgd_module_hooks.priority,
         lotgd_module_hooks.modulename

Can't create/write to file '/var/lib/mysql/tmp/#sql_1c2e_0.MYI' (Errcode: 2)

Call Stack:
1: db_query("SELECT lotgd_module_h...") called from /home/lotgd/public_html/lib/dbwrapper.php on line 64
2: db_query_cached("SELECT lotgd_module_h...", "module_prepare") called from /home/lotgd/public_html/lib/modules.php on line 334
3: mass_module_prepare(Array(

    0=>"template-header", 1=>"template-footer", 2=>"template-statstart", 3=>"template-stathead", 4=>"template-statrow", 5=>"template-statbuff", 6=>"template-statend", 7=>"template-navhead", 8=>"template-navitem", 9=>"template-petitioncount", 10=>"template-adwrapper", 11=>"template-login", 12=>"template-loginfull", 13=>"everyhit", 14=>"header-badnav", 15=>"footer-badnav", 16=>"holiday", 17=>"collapse{", 18=>"collapse-nav{", 19=>"}collapse-nav", 20=>"}collapse", 21=>"charstats"

)) called from /home/lotgd/public_html/common.php on line 187
4: require_once("/home/lotgd/public_html/c...") called from /home/lotgd/public_html/badnav.php on line 6

its on all my pages.
http://lotgd.starwarsreality.com
« Last Edit: November 02, 2005, 05:08:25 PM by renakh » Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #4 on: November 02, 2005, 01:37:16 PM »

The line before "Call Stack" is also important for identifying the error...
Logged

Running for more than three years now:
renakh
Guest
« Reply #5 on: November 02, 2005, 05:10:19 PM »

sorry about that, When I tried to install some of the mods the first time around, it send me a error about not finding the install.php for dag. Would this be something like that?
« Last Edit: November 02, 2005, 05:10:51 PM by renakh » Logged
Kendaer
Guest
« Reply #6 on: November 02, 2005, 08:23:09 PM »

The error you are having
Code:
Can't create/write to file '/var/lib/mysql/tmp/#sql_1c2e_0.MYI' (Errcode: 2)
means that your database table is somehow not writable/corrupt

This is a mysql error, not a game error.

You should try repairing the database tables and if that doesn't work see if you can get help from the fine folks at mysql.com.
Logged
renakh
Guest
« Reply #7 on: November 07, 2005, 01:42:19 AM »

the problem was I didnt have a tmp database. Once I did that everything was fine.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Welcome to DragonPrime - The LoGD Resource Community!

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Who's Online
46 Guests, 1 User
Aeolus
DragonPrime LoGD
Recent Topics
Home Forums News Links Downloads Login Register Advanced Search