DragonPrime - LoGD Resource Community
Welcome Guest
  • Good evening, Guest.
    Please log in, or register.
  • June 28, 2016, 06:48:26 PM
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 64464 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
Please take the time to read the FAQ and browse the DragonPedia

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